new mesure if column X starts with XXX and column B is empty then new mesure is queal to columns X

[dudu55]

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!

[selimovd · Accepted 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'
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd]

Hey @dudu55 ,

did my calculated column give you the result you wanted?

I'm curious if you could solve this issue 🙂

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[ryan_mayu]

@dudu55 

maybe you need to create a column not a measure?

could you pls provide some sample data and expected output?