topic YTD 2023 2019 in DAX Commands and Tips

YTD 2023 2019

mashek — Tue, 24 Jan 2023 16:11:09 GMT

Hi All,

We selected following filter on "Years" ( 2023, 2021 ) Comparing data of 2023, 2021 and looking only YTD data only.

Current year 2023 Date: 24-JAN-2023
Comparing Year 2021 : 24-JAN-2021

We would like to display QTY result on visual only YTD meaning 2021 QTY data only up to 24-Jan-2021 and 2023 QTy Data upto 24-Jan-2023.

At present for yer 2021 it display complete 2021 years data.

Can any one please suggest DAX formula to get data of 2021 and 2023 between 01-JAN and 24-JAN.

Thanks,

Re: YTD 2023 2019

johnt75 — Tue, 24 Jan 2023 17:23:58 GMT

Try

YTD QTY = VAR SelectedYear = SELECTEDVALUE ( 'Date'[Year] ) VAR YearsToSubtract = SelectedYear - YEAR ( TODAY () ) RETURN CALCULATE ( SUM ( 'Table'[Quantity] ), DATEADD ( DATESYTD ( 'Date'[Date] ), YearsToSubtract, YEAR ) )

Re: YTD 2023 2019

mashek — Tue, 24 Jan 2023 20:04:39 GMT

Hi,

I tried and getting only result of 2023 year and not for year 2021.

If I select year 2021 and 2022 it should calculate result of full year of ( 2021 and 2022).

In my selection (2021 and 2023) getting in correct result.

By selecting year 2023 and 2021 it should calculate only YTD, ( Period JAN and day between 01 and day 24 ) for year ( 2021, 2023).

Thanks