YTD Var measure

[ROG]

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! 😊

[Anonymous · Accepted solution]

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