Forum Discussion
Tableau Fixed calculation to Power BI DAX
Hi All,
Could you please help me to convert this Tableau to Power bi DAX.
"ZN(COUNTD(IF [Quarter]>='18-Q4' THEN
IF [LeadNumber] <> 'value' and [MetricName]='value' and [HoldFlag]=1 AND [ActiveCampaignFlag]=1 and
[UniqueInteractionRank]=1
then [LeadNumber] END
ELSE
IF [LeadNumber] <> 'value' and [MetricName]='value' and [HoldFlag]=1 and
[UniqueInteractionRank]=1
then [LeadNumber] END
END))
"
Thanks,
Satish
2 Replies
v-jianboli-msftCommunity Support
Hi Satishkumarr ,
What kind of result do you want? Is it a calculated column or a measure?
Can you elaborate on the logic of your calculation?
Please provide me with more details about the result you want or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-jianboli-msft,
I need a Calculated column, This is a caluclation to define Interactions column.
