cancel
Showing results for
Did you mean:
Frequent Visitor

## Time Intelligence DAX not working for YTD PY

https://easierway-my.sharepoint.com/:v:/g/personal/crisher_1path_com/EcfiDHzpFMNEsAzofeM3focBnOENYky...

Hey everyone. The above is a video of what I am getting. Effectively, I have tried to use the time intelligence functions, but I am still getting the wrong number.

m_BillingTotalCY YTD 2 = TOTALYTD(
SUM(t_STATS_Daily_Billing2[Billing Total]),
t_STATS_Daily_Billing2[Billing Date])

m_BillingTotalPY YTD 3 = CALCULATE([m_BillingTotalCY YTD 2],
SAMEPERIODLASTYEAR(t_STATS_Daily_Billing2[Billing Date])
)

What am I doing wrong?
1 ACCEPTED SOLUTION
Super User

@crisher , Try like

m_BillingTotalCY YTD 2 = TOTALYTD(
SUM(t_STATS_Daily_Billing2[Billing Total]),

You should always use date table for time intelligence

m_BillingTotalCY YTD 2 = TOTALYTD(
SUM(t_STATS_Daily_Billing2[Billing Total]),

example

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

refer if needed

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
2 REPLIES 2
Frequent Visitor

Thanks, everyone. I will give these a try and report back shortly.

Super User

@crisher , Try like

m_BillingTotalCY YTD 2 = TOTALYTD(
SUM(t_STATS_Daily_Billing2[Billing Total]),

You should always use date table for time intelligence

m_BillingTotalCY YTD 2 = TOTALYTD(
SUM(t_STATS_Daily_Billing2[Billing Total]),

example

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

refer if needed

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Announcements

#### Launching new user group features

Learn how to create your own user groups today!