Forum Discussion
Time Intelligence Function is not working
Time Intelligence Function is not working for SAMEPERIODLASTYEAR(), DATESYTD(), TOTALYTD(), etc. Act Month Revenue LY = //CALCULATE(SUM('Module General Ledger'[monthly amount]), SAMEPERIODLASTYE...
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
amitchandak 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?