Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF SUMMARY Dax

Hell all   I am trying to create an IF statement formula to summary results of my cost categories and return me either a TRUE or FALSE. The syntax should be something like the following   IF SUM...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Normally we can use like 

     

    calculate(sum(value),allexcept(table,table[category]))

     

    to get the value group by different category then use IF() funtion to achieve the purpose.

    But i'm not sure what you mean "which are changing though from month to month".

    Can you explain this to us and share some sample data if you don't have any Confidential Information?

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Normally we can use like 

 

calculate(sum(value),allexcept(table,table[category]))

 

to get the value group by different category then use IF() funtion to achieve the purpose.

But i'm not sure what you mean "which are changing though from month to month".

Can you explain this to us and share some sample data if you don't have any Confidential Information?

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.