Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Previous Year DAX

Hi all   I am using the following DAX to calculate the value of a column for the current fiscal year (UK format 1/4/20-31/3/21)   YTDsum = FORMAT(TOTALYTD(SUM(Table[Number]),'Date'[Date], ALL('D...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi v-jingzhang 

     

    Thanks for taking the time to respond, I can't get any of those to work correctly in my report, however I found some DAX that did that I have posted below, granted it is slightly flawed but it does the job 🙂

     

    Prev YTD Calls = CALCULATE(SUM(MitelBICalls[Answered]),DATESBETWEEN('Date'[Date],MAX('Prev Year Date'[Date]),MAX(MitelBICalls[True Date])-366))
     
     
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-jingzhang 

 

Thanks for taking the time to respond, I can't get any of those to work correctly in my report, however I found some DAX that did that I have posted below, granted it is slightly flawed but it does the job 🙂

 

Prev YTD Calls = CALCULATE(SUM(MitelBICalls[Answered]),DATESBETWEEN('Date'[Date],MAX('Prev Year Date'[Date]),MAX(MitelBICalls[True Date])-366))