Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
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!
Solved! Go to Solution.
Thank you Daniel : )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |