Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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!
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |