Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am plotting a cummulative graph from Budgted table to calendar date table using quick measure;
Budgted direct cost is in one table and Calendar is other table.
Solved! Go to Solution.
Hi @Anonymous ,
You could use calculated column to get zero result.
Cumulative =
IF('Table'[Date]>MIN('Table'[Date]),
CALCULATE(
SUM('Table'[Value]),
FILTER('Table','Table'[Date]<=EARLIER('Table'[Date]))
)+0,0)
Here is the result. The value of first date is 0 but not the correct value.
Hi @Anonymous ,
You could use calculated column to get zero result.
Cumulative =
IF('Table'[Date]>MIN('Table'[Date]),
CALCULATE(
SUM('Table'[Value]),
FILTER('Table','Table'[Date]<=EARLIER('Table'[Date]))
)+0,0)
Here is the result. The value of first date is 0 but not the correct value.
Hi @Anonymous ,
Add Zero to your measure and the X-axis should be from dimension table. Find the below measure and screenshot FYR.
Measure:
I cant use the Dim table for X axis as I have to make graphs from diffretent tables. But looks like I have to put zero in my data
Proud to be a Super User!