Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Prior/Last Year DAX same as Current Year

Good day   Can someone please advise where I am going wrong trying to calculate prior year values in my three dax-formulas below?   These three Sales LY should generate the same value, but it is ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Try this formula. 'Table' is data table and 'date' is date table. I create a year column in the date table.

    Measure 2 = CALCULATE(SUM('Table'[value]),FILTER('Table',YEAR('Table'[date])=SELECTEDVALUE('date'[year])-1))

     

     

    Best Regards,

    Jay

nvprasad's avatar
nvprasad
Icon for Solution Sage rankSolution Sage
5 years ago

Hi,

 

Continuous dates are required for all time intelligence calculations. Kindly use the date or calendar table to pass date.

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi nvprasad 

 

Dim_Time is my date table. Can you see something wrong with it? What should I check on it?

 

 

I converted the DAX formulas to pass Dim_Time and not Dim_AccountingPeriod since Dim_Time has continuous dates, but I get the following:

 

 

on the Dim_Time table there are multiple companies/systems which has their own continuous set of dates - could this be an issue? In case it had an issue with multiple entries of a specific date (eg 1/1/2001 for company a, company b and company c), I deleted the other companies so that there is eg on one 1/1/2001 in the Dim_Time table. But that did not solve my problem.