Forum Discussion

shiggs8's avatar
shiggs8
Frequent Visitor
4 years ago

Translate filter from Tableau to Power BI

I need to write this in Power BI but I don't know how to translate from Tableau: Sets Filter =   IIF ([Cust No]<>"0",   (CASE [Days prior refund filter]    WHEN "0"      THEN 1    WHEN "1"    ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

shiggs8 , try like

 

if([Cust No]<>"0" ,

Switch(true() ,

[Days prior refund filter] = "0", 1 ,

[Days prior refund filter] = "1", IF([>0],1,0) ,
),
1)

 

 

shiggs8's avatar
shiggs8
Frequent Visitor
4 years ago

Would this be a calculated column? As I can't use customer number in a measure. Also, [>0] in Tableau is a set, what would be the equivilant in PBI? I currently don't have this value.

Thanks!

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, shiggs8 

     

    What amit writes is a calculated column...And we need to know that [>0] corresponds to the field in powerbi to help you. Can you share some sample data in table format?

    Best Regards,
    Community Support Team _ Janey