Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I am migrating our dashboards from Data Studio to Power BI but I'm having issue wiith DAX.
I used to use case function on Data studio when I want to Calculate 2 conditions but I need help in Power BI
I have a table sales, I need to calculate a bonus payment if the sales person achieve a determined amount and If he achieves a determined % margin.
I have 2 fiels that I created with Sum(Sales) and %Margin
In data studio we use
When [Total sales] > 500000 and [% Margin] > 0.15 then [Bonus]
What is the function that I can use in Power BI??
Please try the below if it works.
SWITCH ( TRUE (),
[Total sales] > 500000 && [% Margin] > 0.15, [Bonus],
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.