Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to rewrite DAX query?

I've created following DAX calculated column with help of variable. I've tried to do the same without variables, but for me using variable is much more simpler.   Besides is it possible to rewrite f...
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    Anonymous

     

    Yes you can rewrite without variables.

     

    There is a method using CALCULATE and ALLEXCEPT, and another method using FILTER and EARLIER.

     

    In general variables avoid repeated evaluation of an expression, but not sure how much that might impact performance in this case - others may have an idea.

  • Baskar's avatar
    Baskar
    9 years ago

    hey , 

     

    Var plays the main important role in DAX. It is Super Hero of Dax. It will cant give performance issue comapre with anyother DAX Functions like Earlier etc ..

     

    I stongly suggest use VAR  

OwenAuger's avatar
OwenAuger
Super User
9 years ago

Anonymous

 

Yes you can rewrite without variables.

 

There is a method using CALCULATE and ALLEXCEPT, and another method using FILTER and EARLIER.

 

In general variables avoid repeated evaluation of an expression, but not sure how much that might impact performance in this case - others may have an idea.