Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

sumifs using multiple table dax

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    Power bi does not support sumif function, I'd like to suggest you use iteration functions to instead. (they allow you to set a table to do looping calculations on it with conditions)

    Since I'm not familiar with excel expressions, can you please explain more about your excel formula calculation logic? (e.g. summary 'X' fields based on 'Y' category and conditions 'Z')

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hi thank you for the reply, 
      do you have any sample solution that i can follow? would help so much thank u.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI Anonymous ,

        It seems like you remove your snapshot, can you please share some sample data and expected result? It is hard to coding formula without any detail information.

        Regards,

        Xiaoxin Sheng