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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
krichmond
Helper IV
Helper IV

I need help converting a Tableau formula into a DAX formula.

I need help converting this Tableau formula into a DAX formula. The field name is "Uninsured Marketing Quantity" and within Power BI the table name is "mv_perfex".

 

IF STARTSWITH([Client Group],'UI') THEN [Quantity] ELSE NULL END

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @krichmond ,

 

How about this :

IF (  LEFT (Table[Client Group], 2 )  = "UI", Table[Quantity], BLANK() ) 

 

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

4 REPLIES 4
tackytechtom
Super User
Super User

Hi @krichmond ,

 

How about this :

IF (  LEFT (Table[Client Group], 2 )  = "UI", Table[Quantity], BLANK() ) 

 

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 

@tackytechtom - I just created the following based on your response:

Uninsured Marketing Quantity = IF(LEFT(mv_perfex[clientgroup], 2) = "UI", mv_perfex[Marketing Quantity], BLANK())
 
However, I am getting the following error message:
<pi>A circular dependency was detected: mv_perfex[Uninsured Marketing Quantity], mv_perfex[Actual Premium With Time Designator], mv_perfex[Uninsured Marketing Quantity].</pi>
 
Any idea what is causing this and how to resolve it?

Hi, @krichmond 

Is mv_perfex[Actual Premium With Time Designator] also a calculated column?

Can you give the relevant formula or a sample file pbix file for further research?

Best Regards,
Community Support Team _ Eason

Hi @krichmond ,

 

Oh oh... circular dependencies ... 

 

I refer to this thread here:

Solved: "A circular Dependency was detected" error while c... - Microsoft Power BI Community

 

Hope 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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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