Forum Discussion
Wiene24
Helper II
Helper IIEOMONTH and SAMEPERIODLASTYEAR
Hi, I am currently calculating the total up to last month by using the following formula: Omzet tm vorig maand = CALCULATE(TOTALYTD([Totaal omzet];FILTER(ALLSELECTED('Datumtabel laadmeter'[D...
Wiene24Helper II
Helper IIHi Anonymous,
The problem is that I can't work with MAX, because we have orders in the future.
With the year it could work because my date table is only untill the end of 2019.
But for the month MAX is maybe october or november, so that will return a different value.
Is there a way I can use EOMONTH in the TITHW?
Kind regards,
Tim Wijnen
HI Wiene24 ,
Can you please share some sample data and expected result for test?
Regards,
Xiaoxin Sheng