Forum Discussion
Row level calculation that adds rows
Hi everyone, I am facing a new issue on my PBI. I have a table in the following format (rand = random number) : month product value dec a rand a dec b rand b dec c rand c ...
Hi Anonymous you can use the below dax to achieve the desire result.
Column = IF('Table'[product] = "d", CALCULATE(SUM('Table'[value]), 'Table'[product] = "c") * 10, 'Table'[value])
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you
Thank you. However, this is not exactly what I want. Product "d" doesn't exist at all in my first table, I want to create it