Time Intelligence Function is not working

[Anonymous]

Time Intelligence Function is not working for SAMEPERIODLASTYEAR(), DATESYTD(), TOTALYTD(), etc.

Act Month Revenue LY = //CALCULATE(SUM('Module General Ledger'[monthly amount]), SAMEPERIODLASTYEAR('Date Table'[Date]))

CALCULATE([Act Month Revenue],SAMEPERIODLASTYEAR('Date Table'[Date]))

Act YTD CY Revenue = CALCULATE(SUM('Module General Ledger'[monthly amount]), FILTER('Module General Ledger','Module General Ledger'[scenario] = "ACT"), FILTER('Module General Ledger', 'Module General Ledger'[account] IN {"40010", "40020", "40030", "40040"}), DATESYTD('Date Table'[Date]))

Act Month Revenue LY column is not showing data.

Act YTD CY Revenue is showing the same value as in Act Month Revenue column

Here I have attached the sample table.

  

Thanks in advance.

[amitchandak · Accepted solution]

@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

[Anonymous]

@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.

[amitchandak]

@Anonymous , to me monthly look like YTD.

Can you share sample data and sample output in table format?

[Anonymous]

@amitchandak 

[Greg_Deckler]

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-TIT...

Also, 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#M56...

And also sound advice on not using them quite frankly.