Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sumifs equivalent Dax not working

Hi Everyone,   I keep getting errors on my Dax and nothing seems to work so I was wondering if someone has come across something similar.     I have a table with all the orders and customer Id's...
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

Power Query won't solve the issue as it shouldn't be used to do Calculations. Your formulas( column = IF...)  are not correct. Can you share a Sample of your model? it's better and faster to help you with your issue  

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    I have attached below an excel example of my data and what they look like.

     

     

    what i want to get frm this calculation that I am trying to do is to be able to get a bar chart showing number of customers that has 5 purchases on theirs records,6,7,10,20 etc.in order to be able to see how many purchases do returning customers tend to have.