topic Re: Different calculation for each row based on a different column in DAX Commands and Tips

Different calculation for each row based on a different column

Anonymous — Fri, 08 Oct 2021 08:23:13 GMT

Hello experts

I am new to Power BI and have a question how to implement the following scenario:

I have a dashboard in which the turnover category is displayed in the first column and a column in which the turnover for the category is displayed. Both come from different tables. However, the calculation is not the same for each category. How can I make a calculation based on the category shown in column 1? Simplified example:

Category	Turnover
A	Field A + Field B
B	Field A + Field C
C	Field A + Field C - Field B

It is not clear to me how I can build a different calculation for each row in column "Turnover" based on column "Category".

I have tried to work with a SWITCH statement. But that doesn't work somehow, but it still uses the same formula for each line.

Thank you for your help

Re: Different calculation for each row based on a different column

jppv20 — Fri, 08 Oct 2021 08:46:35 GMT

Hi Anonymous ,

Could you provide the statement you tried to use? Also, would you like to create a calculated column or a measure?

Jori

Re: Different calculation for each row based on a different column

Anonymous — Fri, 08 Oct 2021 10:41:35 GMT

Hello,

Can you please provide some sample data? This will be of use for anyone trying to help you to achieve the desired outcome.

Looking forward to the reply.

Thanks.

Re: Different calculation for each row based on a different column

Anonymous — Sat, 09 Oct 2021 07:34:25 GMT

Hello together

Yesterday I found a solution that suits me in a different way. Thank you very much for your feedback.

Best Regards

Soooma