Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi i have this formula
Ton1 = CALCULATE(SUM(Lastdata_T[Ton]);DATESBETWEEN(Datum_T[Datum];MAX(Datum_T[Datum])-7;MAX(Datum_T[Datum])))
that returns the end date in a slicer and the 7 previous date in the chart below
Does anynone know how to modify this formula so it doesnt return 7 previous days but the 6 previous months instead ??
Best regards
Petter
Solved! Go to Solution.
@Petter120,
Please check if the following measure returns your expected result.
Ton1 = var Ldate=MAX(Datum_T[Datum]) var Fdate=EDATE(Ldate;-6) return CALCULATE(SUM(Lastdata_T[Ton]);DATESBETWEEN(Datum_T[Datum];Fdate;Ldate))
Regards,
Lydia
@Petter120,
Please check if the following measure returns your expected result.
Ton1 = var Ldate=MAX(Datum_T[Datum]) var Fdate=EDATE(Ldate;-6) return CALCULATE(SUM(Lastdata_T[Ton]);DATESBETWEEN(Datum_T[Datum];Fdate;Ldate))
Regards,
Lydia
I get this error
The following syntax error occurred during parsing: Invalid token, Line 3, Offset 59, [Datum;Fdate;Ldate))))))))))))))))).
// Petter
@Petter120,
I have edited my reply, please re-check the dax.
Regards,
Lydia
Hi Petter
Try this .
CALCULATE(SUM(Lastdata_T[Ton]), DATESBETWEEN( Datum_T[Datum],MONTH(DATEADD(MAX(Sheet2[Date]),-6,MONTH)),Month(MAX(Datum_T[Datum]))))
P.S: I havent tested this as am not at my laptop now. Just edited your formula.
Thanks
Raj
The formula has an error in this section.
Do i have to create another datetable called ("Sheet2[Date]) ?
(MAX(Sheet2[Date])
It gets red even if i put my ordinary date table there as well
CALCULATE(SUM(Lastdata_T[Ton]);DATESBETWEEN( Datum_T[Datum];MONTH(DATEADD(MAX(Datum_T[Datum]);-6;MONTH));Month(MAX(Datum_T[Datum]))))
// Petter
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |