Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter in formular - difference result in Tableau and Power Bi

Hi, 

first of all I would like to say thank to Anonymous guiding me to build  Cohort Analysis in Power Bi. 

but to go further, my real data set I need to filter the Delivery Status Chosen(Choose or Do Not Choose) and B2B(True or False) 

I made CA in Tableau already and just made CA in Power Bi, then compared 2 results together. 

It gives me the different results. 

The correct result in Tableau I made like this - here is the explanation of the formula

For each B2B user, with User ID and filtered Delivery Status Chosen, gives me the 1st month he/she made purchase. 

I used FIXED here, meaning that it will filter the USER ID with Delivery Status Chosen and B2B. 

To find out the different result between Tableau and Power BI, I adjusted formula in Tableau and it gives me the same result in Power Bi. 

Adjusted formula explanation: I take away the Delivery Status Chosen, B2B. It means that it dont care about Delivery Status Chosen and B2B when finding his or her 1st month purchase. 

and this is the formula in Power Bi

Summarize, Adjusted Formula in Tableau = Power Bi formular. 

My question is how to adjust the formular in Power Bi to have the result like in Tableau. 

I guest in 1st Purchase in Power Bi, I have to add filter calculation like the Delivery Status Chosen and the B2B. 

here is the Delivery Status Chosen and  B2B description

 

 

Hope to hear from you!! 

Thanks for reading!

Need Help
Show and Tell

3 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Anonymous 

     

    Values in a calculated column are fixed. They are an immutable result for each row in the table. You just need to create a measure.

    Measure =
VAR d =
    MIN ( Sheet1[ORDER DATE] )
RETURN
    d - DAY ( d ) + 1
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Dear, 

      Thank you for your reply, 

      Could you clarify more about this, pleaese?

      where should I put my measure in the power Bi visualization?

       

      Thanks and hope to hear from you!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Moreover, 

      in this case, the Order Date is for each month of the each. 

      I created the Cohort Analysis to see how many customers comes to business at each month of the year. 

      Just want to clarify more!!