Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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??
Solved! Go to Solution.
@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
@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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |