Forum Discussion
Solved
SUM IF
Hi,
How would I write the following correctly in DAX please
If(
comp[status] = "seg"
and comp[value] <100, 0
else
comp[total_amount])
Hi,
a calculated column with the DAX below should work:
Column = if(and(comp[status] = "seg",comp[value]<100),0,comp[total amount])If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
1 Reply
Hi,
a calculated column with the DAX below should work:
Column = if(and(comp[status] = "seg",comp[value]<100),0,comp[total amount])If I answered your question, please mark my post as solution, Appreciate your Kudos 👍