YTD Var measure

ROG — Tue, 27 Sep 2022 08:33:11 GMT

Hi guys,

I've inherited a report, which has the DAX measure for YTD Variance as per below, which I can understand, but can you please help me to understand the "Vs YTD" and "Vs YTD_2"measure?

Can you please tell what's the DAX measure for YTD Variance?

YTD KPI Value Var = [KPI Value YTD] - [KPI Value LYTD]

[KPI Value YTD] = CALCULATE([KPI Value TY%],DATESYTD('Dim_Date'[Date]))

[KPI Value LYTD] = CALCULATE([KPI Value YTD],SAMEPERIODLASTYEAR('Dim_Date'[Date]))

Vs YTD= DIVIDE([YTD KPI Value Var],[KPI Value LYTD])

Vs YTD_2= [KPI Value TY] - CALCULATE(TOTALYTD( [KPI Value TY%]),Dim_Date[DATE]))

Many thanks inadvance! 😊

Re: YTD Var measure

Anonymous — Wed, 28 Sep 2022 01:52:47 GMT

Hi ROG ,

I created some data:

You can try the following formula:

https://learn.microsoft.com/en-us/dax/varx-p-function-dax

https://learn.microsoft.com/en-us/dax/varx-s-function-dax

Here are the steps you can follow：

1. Create measure.

Measure = var _today=TODAY() return VARX.P(FILTER(ALL('Table'),'Table'[Date]>=DATE(YEAR(_today),1,1)&&'Table'[Date]<=_today),[Amount])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

topic YTD Var measure in DAX Commands and Tips

YTD Var measure

Re: YTD Var measure