Search code examples
powerbi

Using an IF statement in Power BI

I have a really simple equation in Excel, where I choose the measurement unit for the length of wire I want, and it converts every value to mm.

How would I do something similar in Power BI, where I can choose the measurement unit (eg mm, inch, m etc) and then manually input the value to give a result in mm to use at a later stage.

Thanks DF

The IF statement works fine in Excel, but I cannot find the way to do it in PBI

Solution

  • To write If statement in your PowerBI column , you can Create a new measure and then write your conditions in that measure and you are ready to go. second thing is , you can duplicate the column and use filters in that using IF conditions.