Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
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, ...
ISW's user avatar
  • 33
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... ...
m1nkeh's user avatar
  • 1,397
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 ...
user2751154's user avatar
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 ...
Felix Merlin Bennet's user avatar