Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to write a measure (DSO_Measure) that I could reference a value (DaysInMonth) on dim table (Calendar) because there are relationships with other two Fact tables (AR_Aging & Transactions) to do a calculation.
This is a measure (DSO_Measure) I am trying to write to do a calculation:
I tried with as shown on the bottom, but it did not get the right calculation numbers.
There is a relationship between two Fact tables (AR_Aging & Transactions) and Calendar (dim) table.
Bottom is an image for the dim table (Calendar).
I only captured the portion of image for February 2022 value (DaysinMonth), which is 28.
How do I express so that it could reference the right month?
For this case, it should only point to 28 for February 2022.
If it is January or December, it should reference 31 in the Calendar table.
If it is November or September, it should reference 30 in the Calendar table, etc..
Thanks.
Solved! Go to Solution.
A simplest application of expanded table,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
A simplest application of expanded table,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
27 | |
24 | |
13 | |
8 |
User | Count |
---|---|
74 | |
56 | |
47 | |
16 | |
12 |