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 to calculate Cumulative value total on monthly for ecah year. I gave Visual level filter for 1 year (Find in below screenshot).
Datatable has calender Date relationship with Date column in data table below.
Expect value should be like:
Jan - 2,667
Feb - 5,334
Mar - 8,001
April - 10,668 .
........
I don't know how below measure is calculating this value. I am geeting wrong value.
Please let me know if i am misisng anything.
Thanks in advance!
Hi,
Share some data and show the expected result.
Try something like this:
Measure = var __DateToConsider = MAX(DateTable[Date]) return CALCULATE( SUM(Financial[Financial Target], DateTable[Date] <= __DateToConsider )
First, you find the max date within the filter context and store it in a variable. For example, in a row of your table visual, the max date would be the last date of that month.
Then you use the stored value to compare with each date in the DateTable. This overrides the original filter context with the new filter context (less than or equal to last date of original filter context).
Hope this helps,
Nathan
It's not working as expected.
I notice some wierd thing -
1. I worte a measure for particluar value, it is working fine( without slicer).
Measure =
CALCULATE (
[Sum of financial],
FILTER (
ALL ( Financial ),
Financial[Month!] <= MAX ( Financial[Month!] )
&& Financial[Queue Name] = "OCOE-CRM-Task Resolution"
)
)
Right output :
Jan - 2,667
Feb - 5,334
Mar - 8,001
April - 10,668 .....................
2. I wrote same measure with storerd sclier selection value. (Slicer selection = SELECTEDVALUE(Financial[Queue Name]), and this measure i am in below measure as slicer slection value.
Try it with a variable.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |