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 dataset of number of claim submitted from client and want to show in MTD value and YOY compare with last year number. My DAX formula result is correct in table but show blank value in card.
Please help in this issues,
1. Show MTD in card visual (1878)
2. Iwant to show %YOY as of today (my data as of 14/1/2020 so should show 11.26%) not show total change like this
Thanks in advance
YOY_PERCENT_GROWTH_YTD_NUMBER_OF_CLAIM = DIVIDE(CLAIMS_DATASET[YOY_GROWTH_YTD_NUMBER_OF_CLAIM],[PRV_YTD_NUMBER_OF_CLAIM])
MTD_NUMBER_OF_CLAIM = TOTALMTD(CLAIMS_DATASET[TOTAL_NUMBER_OF_CLAIM], 'DIM_DATE'[Date].[Date])
Solved! Go to Solution.
In case of MTD remove .date
MTD_NUMBER_OF_CLAIM = TOTALMTD(CLAIMS_DATASET[TOTAL_NUMBER_OF_CLAIM], 'DIM_DATE'[Date])
Current MTD will only come when we select the month. else it will take end date of calendar as date.
You can put a slicer or restrict max date of calendar.
In case of YTD, either select a date in slicer of push a filter
Example
YTD_NUMBER_OF_CLAIM =
var _max = maxx(CLAIMS_DATASET,CLAIMS_DATASET[Date])
return
calculate(TOTALYTD(CLAIMS_DATASET[TOTAL_NUMBER_OF_CLAIM], 'DIM_DATE'[Date]),'DIM_DATE'[Date] <=_max )
\\Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
In case of MTD remove .date
MTD_NUMBER_OF_CLAIM = TOTALMTD(CLAIMS_DATASET[TOTAL_NUMBER_OF_CLAIM], 'DIM_DATE'[Date])
Current MTD will only come when we select the month. else it will take end date of calendar as date.
You can put a slicer or restrict max date of calendar.
In case of YTD, either select a date in slicer of push a filter
Example
YTD_NUMBER_OF_CLAIM =
var _max = maxx(CLAIMS_DATASET,CLAIMS_DATASET[Date])
return
calculate(TOTALYTD(CLAIMS_DATASET[TOTAL_NUMBER_OF_CLAIM], 'DIM_DATE'[Date]),'DIM_DATE'[Date] <=_max )
\\Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Hi @amitchandak ,
Thank you for your reply.
Is it possible to show MTD in present month without select month in slicer?
In visual level filter drag the date (date used in MTD or ytd) and use relative date filter and set it to this month , today etc.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |