Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |