MTH/QTR/YTD Slicer Same Period Last Year

Anonymous — Tue, 10 Mar 2020 22:25:56 GMT

Hi All,

I have created a slicer for financial periods MTH,QTR,YTD 'Select Period' then I use it filter the columns. What is the DAX for equivalent last year, so same month last year, same qtr last year and last year?

< New Total GWP = CALCULATE(SUM('PA New Business'[GWP]))

--Slicer wrapper around measure for current year

Slicer GWP = if(HASONEVALUE('Select Period'[Period]),
            SWITCH(VALUES('Select Period'[Period]),
            "MTH", CALCULATE([New Total GWP],DATESMTD('PA New Business'['Issue Date (Formatted)])),
            "QTR", CALCULATE([New Total GWP],DATESQTD(DATESMTD('PA New Business'['Issue Date (Formatted)]))),
            "YTD", CALCULATE([New Total GWP],DATESYTD(DATESMTD('PA New Business'['Issue Date (Formatted)])))),
            CALCULATE([New Total GWP],DATESMTD('PA New Business'['Issue Date (Formatted)]))) />

< LYTD GWP = CALCULATE([New Total GWP],SAMEPERIODLASTYEAR(DATESYTD('Date'[Date])))

LQTR Count = CALCULATE('_Measures'[New Bus Count],PREVIOUSQUARTER(DATESYTD('Date'[Date])))

--Slicer wrapper for Same period last years MTD/QTR/YR ??

Slicer LY GWP = if(HASONEVALUE('Select Period'[Period]),
            SWITCH(VALUES('Select Period'[Period]),
            "MTH", CALCULATE([New Total GWP],DATESMTD('PA New Business'['Issue Date (Formatted)])),
            "QTR", CALCULATE([New Total GWP],DATESQTD(DATESMTD('PA New Business'['Issue Date (Formatted)]))),
            "YTD", CALCULATE([New Total GWP],DATESYTD(DATESMTD('PA New Business'['Issue Date (Formatted)])))),
            CALCULATE([New Total GWP],DATESMTD('PA New Business'['Issue Date (Formatted)]))) />

Thanks for any help.

Re: MTH/QTR/YTD Slicer Same Period Last Year

Anonymous — Tue, 10 Mar 2020 10:50:04 GMT

Let me quote: "But how do i format the DAX for equivalent last year..."

If you want to format your DAX, then you www.daxformatter.com.

Best
D

topic MTH/QTR/YTD Slicer Same Period Last Year in DAX Commands and Tips

MTH/QTR/YTD Slicer Same Period Last Year

Re: MTH/QTR/YTD Slicer Same Period Last Year