Waterfall chart YOY YTD

[Anonymous]

Hi,

I created a waterfall chart associated with a period slicer.

I want to compare data YTD for 2018 and YTD for 2019. As you can see it takes full year turnover for 2018.

How can I compare YTD 2018 and YTD 2019 with a DAX measure?

Here : from 2018-01-01 to 2018-01-03 and 2019-01-01 to 2019-01-03

Thanks

[Anonymous]

[Base Measure YTD LY] = // year-to-date last year
	CALCULATE(
		[Base Measure],
		SAMEPERIODLASTYEAR(
			DATESYTD( Calendar[Date] )
		)
	)

Best

D

[Anonymous]

Hello,

Thank you for your answer, but this measure only gives last year's turnover.

I would like to select a period, and if the period is between 2018-01-02 and 2019-01-05 the cascade will display :

- in the 2018 bar -> sum of turnover between 2018-01-02 and 2018-01-05

- in the 2019 bar -> sum of turnover between 2019-01-02 and 2019-01-05

If too complicated only YTD turnover for 2018 until 2018-01-05 and YTD for 2019 until 2019-01-05.

How can I get this result?

[Anonymous]

https://www.sqlbi.com/tv/time-intelligence-in-microsoft-power-bi/

https://radacad.com/basics-of-time-intelligence-in-dax-for-power-bi-year-to-date-quarter-to-date-mon...

Best
D