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.
Here is my structure.
Here is my "setup varejista" table
What I am trying to do :
Create a calculated column ("N5MP") in my product table that checks the setup varejista[#N] and calculates the field based on its value. And here is my product table structure:
Here is what I came up with so far, but it does not work. it always returns the else case of the switch
Not sure aboute the variable setting, not very good with DAX, because of the data structure I cannot acces the "setup varejista" from the product table in order to do the calculation, So i tought agoint checking it some other way and then bringing that value to my table...
What am I doing wrong/ how do I do this?
@Anonymous
The problem is that there is no context for the SELECTEDVALUE expression (so it sees no value).
Why do you need this as a Calculated column? You could easily do the calculation in a measure for a visual.
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
46 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
61 | |
50 | |
45 | |
20 | |
17 |