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.
Is there a good way to overcome the problem below? My chart is showing cumulative stock and it is totally correct with the last horizontal line as there are no stock movements anymore.
However, I would prefer line to end completely at its last value.
I did modify my formula to return zero after today but it didn't work the way I wanted. I want no value at all instead of zero.
AccumulatedValue = IF( TODAY()<=MAX('Calendar'[Date].[Date]); 0; (CALCULATE ( SUM ( 'Item Ledger Entry'[Quantity] ); FILTER ( ALL ( 'Calendar' ); 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) )) ))
Jenny
Solved! Go to Solution.
Hi Jenny,
Just try to delete .[Date] from your formula. It should work.
AccumulatedValue = IF( TODAY()<=MAX('Calendar'[Date].[Date]); 0; (CALCULATE ( SUM ( 'Item Ledger Entry'[Quantity] ); FILTER ( ALL ( 'Calendar' ); 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) )) ))
Best Regards!
Dale
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |