Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |