topic Re: I need help converting a Tableau formula into a DAX formula. in DAX Commands and Tips

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

krichmond — Wed, 09 Nov 2022 20:16:40 GMT

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

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

tackytechtom — Wed, 09 Nov 2022 20:31:19 GMT

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/

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

krichmond — Wed, 09 Nov 2022 20:57:19 GMT

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?

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

tackytechtom — Thu, 10 Nov 2022 20:20:47 GMT

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/

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

v-easonf-msft — Mon, 14 Nov 2022 07:04:50 GMT

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