Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All,
I am stuck on a verge of closure, please help.
I have a table where i have create 2 column one financials in Euros and another one Financials in Dollar.
I need to display the values as per filter Selection of currency - Euro/USD
I tried switch function, it did not work for multiple values hence i thought of creating another another column with IF Statement and take the output for my work but i am getting the above error, Please guide it is urgent. I need the output in column to create waterfall chart of financials
Solved! Go to Solution.
@Anonymous
You are trying to create a column with a slicer value. Only a measure can use Slicer Value.
new mesure =
if([selected Value] ="EUR",max(Waterfall[Result]),max(Waterfall[Result2]))
@Anonymous
You are trying to create a column with a slicer value. Only a measure can use Slicer Value.
new mesure =
if([selected Value] ="EUR",max(Waterfall[Result]),max(Waterfall[Result2]))
hi @Anonymous
try SELECTEDVALUE():
= if(selectedvalue([selected currency]) = "eur", [Result], [Result2])
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
85 | |
82 | |
65 | |
49 |
User | Count |
---|---|
138 | |
110 | |
104 | |
66 | |
64 |