Forum Discussion

Satishkumarr's avatar
Satishkumarr
Frequent Visitor
3 years ago

Tableau Formula to Power BI DAX

Could someone please help converting this to DAX.

 

"zn(if max([Quarter]) < 'value' then
if max([Segment Selection Flag Quarter]) = TRUE or [Segment Selection Flag] = TRUE then NULL else
zn(SUM({ FIXED [Quarter],[Geo],[Campaign BU],[Area]: MAX([GoalUniqueInteractions])}))
end
else
zn(SUM({ FIXED [Quarter],[Geo],[Campaign BU],[Segment],[Area]: MAX([GoalUniqueInteractions])}))
end)

"

 

Thanks,
Satish.

1 Reply

  • Fatema123's avatar
    Fatema123
    Frequent Visitor

    FIXED [Quarter],[Geo],[Campaign BU],[Segment],[Area]: MAX([GoalUniqueInteractions])

     

    Can you please explain what does this return?