Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Time Intelligence functions

Hi,   I have very simple data and wanted to write dax for some time intelligence functions like as YTD, LYTD, Last 12 months rolling, sameperiodlastyear.   I have filters as Year and Month.   W...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Ashish,

 

When I tried to create Sameperiod last year it is not giving the correct results.

 

Same selected Month and Year but Last Year:

CALCULATE(SUM(Amount),SAMEPERIODLASTYEAR(Date))

 

I am trying below requirement as well, but couldn't success.

 

YTD: My financial year starts from APRIL to MARCH when I selected 2022 and APRIL. I suppose to see 2022 APRIL to 2023 March.  not sure how to get this done.

 

Last Year YTD: When I select 2022 APRIL then I supposed to see 2021 APRIL to 22 MARCH.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    I am not sure of what you want.  Share some data and show the expected result.