Hi! I want to have one column with the sum of others 2 categories, like the example (result = bota+tenis):
in excel I use the formula (tradution of portuguese: SE = IF, OU = OR):
I attempted to do this in Data View, but it failed because the data is linked via Direct Query, and I don't know how to do this on Power Query. 😭 pls help
Hello @Anonymous ,
Refer to this link https://learn.microsoft.com/en-us/power-query/add-conditional-column
If I answered your question, please mark my post as solution, Appreciate your Kudos👍
Proud to be a Super User! |  |
Hello @Anonymous ,
Refer to this link https://learn.microsoft.com/en-us/power-query/add-conditional-column
If I answered your question, please mark my post as solution, Appreciate your Kudos👍
Proud to be a Super User! | |
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
