How to convert tableau to power bi formula

[naftycs]

Hello professionals. I am new to DAX. I want to convert this tableau formula into DAX appreciate your help:

STR(if ISNULL([Student ID]) then [Registration Number] else [Student ID] END)

Thank you for your time and for helping me with my learning process.

[tackytechtom · Accepted solution]

Hi @naftycs ,

I have never used Tableau, but I'll give it a shot. My assumption is that both Student ID and Registration Number have the same data type plus that you'd want to create a calculated column.

Calculated Column = 
IF ( Table[Student ID] = BLANK(), Table[Registration Number], Table[Student ID] )

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/