Forum Discussion
Comparing a Column with Strings with a specific Value
Hi Anonymous ,
Can I suggest you using a conditional column in Power Query first to get your desired column.
Did I help you today? Please accept my solution and hit the Kudos button.
Hey davehus,
thank you for your reply.
I dont use Power Query. In the past, I exported the raw Power Bi data to Excel and then adjusted it there. Now I want to store the required calculations directly in Power Bi, which come from SAP. Or am I missing something?
Hi Anonymous ,
You do use powerquery, you just may not have noticed. 🙂 It is the editor that is used when you click transofrm data in powerbi. Once you import your data, go to transform in the powerquery editor and select conditional column, you can use it to build an if statement based on your needs and select a column rather than a value to get data from each column based on the price.
Hope this helps