Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
naftycs
Regular Visitor

How to convert tableau to power bi formula

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.

 

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

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/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

1 REPLY 1
tackytechtom
Super User
Super User

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/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors