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.
My goal is to go from Picture 1 to Picture 2(below). I have 3 calculations for the running totals. My challenge is with the yellow line. The yellow line calculations does not stretch to the final year and I want it to be able to flatline to the end.
My DAX calculation for the yellow line is like so:
CALCULATE(SUM('Table1'[Value]),
FILTER(ALLSELECTED('Table2'[Date]),
ISONORAFTER('Table2'[Date], MAX('Table2'[Date]), DESC))
This^ calculation works great for calculating the running total, except it stops once there is no data. I want it to do what is shown in Picture 2 - to strech til the end. Does anyone know how to accomplish this? Thanks!
Picture 1:
Picture 2:
Solved! Go to Solution.
@sunnysideup96 , Make sure table 2 is a date table, maked as a date table, and have a single directional join
Try like
CALCULATE(SUM('Table1'[Value]),
FILTER(ALL('Date'[Date]),
ISONORAFTER('Date'[Date], MAX('Date'[Date]), DESC))
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
@sunnysideup96 , Make sure table 2 is a date table, maked as a date table, and have a single directional join
Try like
CALCULATE(SUM('Table1'[Value]),
FILTER(ALL('Date'[Date]),
ISONORAFTER('Date'[Date], MAX('Date'[Date]), DESC))
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |