Possibility of Cell level calculation in Power BI

[Yashi]

I am migrating SAP BO Webi reports to Power BI. 

In SAP BO Webi report, visuals are in tabular format but one strange thing I have observed over here is that in a particular column the formula for every row is different. Further, in SAP BO the developers are able to edit the formula in every cell of the column. Now I need to replicate the same tabular visual in Power BI, but in Power BI we usually drag and drop rows and columns so how can we have separate formulas for separate rows in a column?

Kindly let me know if anyone have faced a similar challenge and found a solution for the same.

Thanks

[Idrissshatila]

Hello @Yashi ,

so here it's different, the formula applies to all the cells in a column but the data is shown with respect to the row value.

if you mean you want to replace a specific value in a specific cell you could acheive that through "replace" function in power query.

check it out https://youtu.be/5YEwwpCy8oA?si=hs0yvxlnLyaM7DgU

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡