Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |