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.
Hi,
I have a table with a measure "Limit Amount Our Share GBP" that I need to create a matrix report at each month end. I have created new measures based on Feb & Jan 2019 month end, but need to go back to January 2017 and this report will be used for future months as well.
Rather than creating lots of measures for future & past month ends how can I do t by creating another table listing the month end dates???
Below is an example of the measure I've created and the matrix so far, highlighting the measure and date paramenters.
Any assistance will be great!
Thanks
Jason
Solved! Go to Solution.
Hi @jasgun01,
Sorry I miss the bit where you use two different dates.
You can use the pattern below:
First create Table:
Hi @jasgun01,
You can use calendar table (dimension) with Year Month Column that goes to your Matrix column and just use your Measure without a need for complex dax.
Hope this helps
Mariusz
Hi @Mariusz
Thanks for you assistance once more.
I have added the calendar table to my model, however I have two date field parameters that I use to calculate the measure <= "PolicyIncpetionDate" & >= "PolicyExpiryDate".
I thought about adding the Calendar table twice and have two joins, both on the "Date" but then one to each of the date fields mentioned above.
But thats where I'm stuck! How do I calculate the measure automatically for the two paramenters based on the MonthYearNum on the Calendar table????
Hi @jasgun01,
Sorry I miss the bit where you use two different dates.
You can use the pattern below:
First create Table:
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |