Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX-Calculation best practice

Hi,   I am trying to fix a DAX-calculation were I basically want to take  No of Emails + No of Calls + No of Chats / No of Orders   However there are some filters on each metrics that need to be ...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Great, I'll buy that book!

 

  • How do I massage my data with Power Query in this case? I need to solve this in a short period of time.. Do you have any direction you can point for to more specifically?
  • So KEEPFILTERS instead of FILTER is better?
  • Ok, I'll try that out. 

Can you give an example if I need a flag to filter Source = Genesys as an example. Should I then create a DAX formula for this? 

 

BR Fredrik

daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
3 years ago

Anonymous 

 

Please learn to use Power Query. It can do anything that you could imagine with your data. Most things just by clicking a button. There are millions of vids on YT about Power Query...

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Unfortunately this does not help me at all short term. 
    I need more specific help rather then "learn Power Query".