Forum Discussion
Time Intelligence Function is not working
Time Intelligence Function is not working for SAMEPERIODLASTYEAR(), DATESYTD(), TOTALYTD(), etc.
Anonymous , make sure the date table is marked as a date. and You have all the required date in the date table.
Also, refer
Power BI — YTD Questions — Time Intelligence 1–5
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — MTD Questions — Time Intelligence 3–5
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
5 Replies
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008Also, there is good information on how to get time intelligence functions to work here: https://community.powerbi.com/t5/Quick-Measures-Gallery/To-bleep-With-STARTOFQUARTER/m-p/1240067#M566
And also sound advice on not using them quite frankly.
Anonymous , make sure the date table is marked as a date. and You have all the required date in the date table.
Also, refer
Power BI — YTD Questions — Time Intelligence 1–5
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — MTD Questions — Time Intelligence 3–5
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090eamitchandak Thank You
I marked date table as date.
Now SAMEPERIODLASTYEAR function is working. The table shows the last year data. But still now DATESYTD is showing the same data as in Actual Month Revenue column for each period.
Anonymous , to me monthly look like YTD.
Can you share sample data and sample output in table format?
