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.
Im trying to write new mesure but trully have no idea how to do it , it should be like that :
new mesure = if column X starts with XXX and column B is empty then new mesure is queal to columns X if columnY is queal to YYY new mesure is equal to YYY
how can i write this in new mesure? help!
Solved! Go to Solution.
Hey @dudu55 ,
I guess you want that as a calculated column.
If it's as a column that should work:
new mesure column =
SWITCH(
TRUE(),
LEFT( myTable[column X], 3 ) = 'XXX' && myTable[column B] = BLANK(), myTable[columns X],
myTable[column Y] = 'YYY', 'YYY'
)
Hey @dudu55 ,
I guess you want that as a calculated column.
If it's as a column that should work:
new mesure column =
SWITCH(
TRUE(),
LEFT( myTable[column X], 3 ) = 'XXX' && myTable[column B] = BLANK(), myTable[columns X],
myTable[column Y] = 'YYY', 'YYY'
)
Hey @dudu55 ,
did my calculated column give you the result you wanted?
I'm curious if you could solve this issue 🙂
maybe you need to create a column not a measure?
could you pls provide some sample data and expected output?
Proud to be a Super User!
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |