Forum Discussion

aghonaim's avatar
aghonaim
Most Valuable Professional
8 years ago
Solved

DAX Formula

Can someone help me with a simple formula to calcualte the value of the last year (which is YYYY number not a full date) ? I tried the following formual but it isn't returning any values: LY = Calc...
Need Help
  • SivaMani's avatar
    SivaMani
    8 years ago

    Hi aghonaim,

     

    Sorry. Recreate it as a calculated column.

AlbertoFerrari's avatar
AlbertoFerrari
Most Valuable Professional
8 years ago

The question is: "what do you want to see at the grand total"? Showing the value for 2012 looks a good compromise, but if you want to fix it, you first need to decide what to show there. At the grand total - being no year in the selection - the very value of "last year" is undefined.


Have fun with DAX!

Alberto Ferrari
http://www.sqlbi.com

  • aghonaim's avatar
    aghonaim
    Most Valuable Professional
    8 years ago

    That's what I want to get which SivaMani solution allowed me to get it:

     

     

    Makes sense ?

    Is there a measure can do that ? if yes, which one is better/faster ?