Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I use this formula for the cumulative total of forecasted cartons.
Solved! Go to Solution.
@Tavi_ OK, didn't understand that from the original post:
_Forecast Cartons Cumulative =
VAR __Value = CALCULATE(
[_Forecast Cartons],
FILTER(
ALL('[DIM] Date'[Date]),
'[DIM] Date'[Date] <= MAX ('[DIM] Date'[Date]) && '[DIM] Date'[Date] >= TODAY() )
)
VAR __Result = IF( MAX('[DIM] Date'[Date]) < TODAY(), BLANK(), __Value )
RETURN
__Result
@Khushidesai0109 your formula shows me this figures
@Greg_Deckler your formula shows me this figures
Both not the figures I'm looking for. De formula must ignore al the cartons before today.
@Tavi_ OK, didn't understand that from the original post:
_Forecast Cartons Cumulative =
VAR __Value = CALCULATE(
[_Forecast Cartons],
FILTER(
ALL('[DIM] Date'[Date]),
'[DIM] Date'[Date] <= MAX ('[DIM] Date'[Date]) && '[DIM] Date'[Date] >= TODAY() )
)
VAR __Result = IF( MAX('[DIM] Date'[Date]) < TODAY(), BLANK(), __Value )
RETURN
__Result
Hii You can use this DAX Instead
Forecast Cartons Cumulative =
CALCULATE (
[_Forecast Cartons],
FILTER (
ALLSELECTED ( '[DIM] Date'[Date] ),
'[DIM] Date'[Date] <= MAX ( '[DIM] Date'[Date] )
)
)
_Forecast Cartons Cumulative =
VAR __Value = CALCULATE(
[_Forecast Cartons],
FILTER(
ALL('[DIM] Date'[Date]),
'[DIM] Date'[Date] <= MAX ('[DIM] Date'[Date]))
)
VAR __Result = IF( MAX('[DIM] Date'[Date]) < TODAY(), BLANK(), __Value )
RETURN
__Result
User | Count |
---|---|
119 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |