I have a financial calculation problem to ask and would appreciate any kind help!
In the table below, AA_100010 and AA_100020 are empty numbers. They are values from additions of other cells.
What I would like to have is creating a new column in Power Query where
IF [AACT_NUMBER]= AA_100010 Then [New Value] is AA_100011+AA_100014 which equals to 17
ELSE IF [AACT_NUMBER]= AA_100020 Then [New Value] is AA_100021 + AA_100023 which equals to 26
ELESE Return values in the [VALUE] column
Thanks in advance for the help from Taiwan!
Go to Solution.
View solution in original post
Thank you Daniel : )
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.