Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I am new to power bi and need help with a calculation.
I have three columns: "Anzahl Lieferanten", "Anzahl Hersteller" and "Zeit bis EOL" (in days). Now I want to assign a value from 1-3 to each of the values in the columns if they are greater or less than certain values. the resulting values I then want to multiply.
I have thought of something like this:
Of course, it doesn't work that way. Maybe someone can help me? Thanks in advance!
Solved! Go to Solution.
Hello @weberna ,
The issue is with the syntax of the switch statement.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Hello @weberna ,
The issue is with the syntax of the switch statement.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Thank you so much Rohit!
Now it works perfectly 🙂
Hi @weberna
You missed the ( , ) after TRUE ( ) in the first variable. Also delete the ( " " ) from around the numbers. Eg. write 1 not "1"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
54 | |
27 | |
23 | |
14 | |
11 |
User | Count |
---|---|
77 | |
62 | |
44 | |
17 | |
12 |