datesytd not working?

Anonymous — Tue, 05 Jul 2022 09:26:06 GMT

I have the next DAX code:

VAR CALC1 = CALCULATE( [Headcount R12Avg], 'Date'[IsPastDays] = 1) VAR CALC2 = CALCULATE( [Resignations R12], 'Date'[IsPastDays] = 1) RETURN CALCULATE( DIVIDE( CALC2, CALC1), DATESYTD( 'Date'[Date], "31/05") )

But whenever I remove the 'datesytd.... ' I get the same value?

How is it possible that both CALCULATE( DIVIDE( CALC2, CALC1), DATESYTD( 'Date'[Date], "31/05") )

and DIVIDE( CALC2, CALC1)

Return the same value??

Re: datesytd not working?

amitchandak — Tue, 05 Jul 2022 10:27:36 GMT

Anonymous , Try like

VAR CALC1 = CALCULATE( [Headcount R12Avg], filter('Date', 'Date'[IsPastDays] = 1))
VAR CALC2 = CALCULATE( [Resignations R12], filter('Date', 'Date'[IsPastDays] = 1))
RETURN

CALCULATE( DIVIDE( CALC2, CALC1), DATESYTD( 'Date'[Date], "31/05") )

Also make sure, date table is marked as the date table

Filter/slicer/ visual use period from date table only

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

topic datesytd not working? in DAX Commands and Tips

datesytd not working?

Re: datesytd not working?