Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I would like to create a running total but only for the current month and ongoing(future months).
Can anybody advise me how I can achieve this?
Amount To Be Delivered Running Total =
CALCULATE(
SUM(Milestones[Amount Delivered (€)]),
FILTER(ALLSELECTED(DateDim),
DateDim[Date Month]<=MAX(DateDim[Date Month]
)))
Solved! Go to Solution.
Hi @Kpham ,
If "current month" means the actual current month,you should use below dax expression:
Amount To Be Delivered Running Total =
CALCULATE(
SUM(Milestones[Amount Delivered (€)]),
FILTER(ALLSELECTED(DateDim),
DateDim[Date Month]>=Month(Today())
)))
but if "current month" depends on the filter selection,the expression should be:
Amount To Be Delivered Running Total =
CALCULATE(
SUM(Milestones[Amount Delivered (€)]),
FILTER(ALLSELECTED(DateDim),
DateDim[Date Month]>=MAX(DateDim[Date Month]
)))
@Kpham , try like
Amount To Be Delivered Running Total =
if(eomonth(max(DateDim[Date Month]),0) = eomonth(today(),0), CALCULATE(
SUM(Milestones[Amount Delivered (€)]),
FILTER(ALLSELECTED(DateDim),
DateDim[Date Month]<=MAX(DateDim[Date Month]
))) , blank())
Hi @Kpham ,
If "current month" means the actual current month,you should use below dax expression:
Amount To Be Delivered Running Total =
CALCULATE(
SUM(Milestones[Amount Delivered (€)]),
FILTER(ALLSELECTED(DateDim),
DateDim[Date Month]>=Month(Today())
)))
but if "current month" depends on the filter selection,the expression should be:
Amount To Be Delivered Running Total =
CALCULATE(
SUM(Milestones[Amount Delivered (€)]),
FILTER(ALLSELECTED(DateDim),
DateDim[Date Month]>=MAX(DateDim[Date Month]
)))
That should be >= , not <=
Also note that "current month" depends on your filter context, and can have a different meaning from what you expect.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |