Forum Discussion
Solved
Replacing Values in the Visual (Calculated) Column
Dear All: All the best in all the reporting. I am too new to Power BI but the current stage where I am stuck has made me Go Through Power BI a lot. A blessing in disguise. :) I need to Replace the ...
=IF([Measure1]=blank(),[Measure2],[Measure3])
or some variation. You can use nested IF if needed, or even SWITCH TRUE
https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/
I mean you should write a measure that reacts to the circumstances that are presented in the visual.
=IF([Measure1]=blank(),[Measure2],[Measure3])
or some variation. You can use nested IF if needed, or even SWITCH TRUE
https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/
THANKS for the reply, did you mean that I need to create the Columns in visuals using "new measure"? Instead of using "New Column" or making the column calculated by the VISUAL TABLE'S filters?
I mean you should write a measure that reacts to the circumstances that are presented in the visual.
Perfect solution you have quoted Matt... very nice. My issue resolved as well.
I have had been stuck since days over it.. Good Luck.
Thanks,