All Questions
4 questions
1
vote
0
answers
1k
views
SAMEPERIODLASTYEAR for only values in current year
I'm trying to show the value from prior year for products. I only want the products that are present in the current year to show.
What I would like:
Product SamePeriodSalesLastYear
1, ...
0
votes
1
answer
153
views
Tabular DAX Daily Many To Many Association
I am almost at the end of my tether on a problem that i have in a model currently... basically, i have a 'temporal' many to many mapping table which maps commission rates for managers over time... ...
1
vote
2
answers
369
views
DAX calculated measure location
I am a new DAX user and I am clearly mis-interpreting how the language handles relationship propagation for calculated measures and I am hoping someone can help me out with what I thought was a simple ...
1
vote
0
answers
338
views
Aggregate an attribute hierarchy in SSAS Tabular Model
I have created a tabular model using SSAS 2012 and i'm having an attribute hierarchy called "Date" (yyyy-MM-01T00:00:00 format) with 12000 records in it. I found a built-in function "Aggregate" to ...