topic Re: Need to measure last year and this year until yesterday in DAX Commands and Tips

Need to measure last year and this year until yesterday

Anonymous — Wed, 24 Apr 2019 06:06:57 GMT

So quite new at this but need to calculate this year against last year until yesterday. Because I get data only once a night. So the data I have today is for yesterday.

Now it shows data for yesterday lets say 300 000euros and it is 01.01.2019-23.04.2019 and the target goal is sameperiod lastyear and it shows 305 000euros but it is for 01.01.2018-24.04.2018 so it shows as -1,66%

In this instance i use KPI slicer and my measures are Indicator :

Total Euros MTD = IF( LASTDATE( Dates[Date] ) > TODAY(), BLANK(), CALCULATE( [Total Euros], DATESMTD( Dates[Date])))

target goal :

Total Euros MTD LY =

IF( LASTDATE( Dates[Date] ) > TODAY(),

BLANK(),

CALCULATE( [Total Euros LY], DATESMTD( Dates[Date])))

Re: Need to measure last year and this year until yesterday

verscev — Wed, 24 Apr 2019 15:03:04 GMT

Hello Anonymous ,

When calculating ou MTD LY, try using the SAMEPERIODLASTYEAR function.

First calculate you MTD of the current period, which will take into account that no data is available for today, and then move the period to last year with the SAMEPERIODLASTYEAR function.

Evi

Re: Need to measure last year and this year until yesterday

Anonymous — Fri, 10 May 2019 12:42:39 GMT

Hello,

Have tried this different ways

Total Euros MTD = if( lastdate( Dates[Date] ) > today(); blank(); calculate( [Total Euros]; Datesmtd( dates[date])))

Total Euros MTD LY = CALCULATE(TOTALMTD(SUM(wl_cargo[EURSEK]); Dates[Date]); SAMEPERIOdLASTYEAR(Dates[Date]))

But it still shows the whole month for last year.

Any other ideas? Can I filter the ly for today -366?