Forum Discussion

Huongluu's avatar
Huongluu
New Member
3 years ago

How to calculate Difference from Base Line (like FireBase in AB testing)

Hello Every One,

I am newbie in Power BI

I want to controll all Firebase AB testing of all projects in a dashboard. 

- I get all data from Bigquery 

- I mark 0 is control user, 1 is target user

My table like: 

ID_AB_UnitExperiment_VariantUser_pseudo_idVersionRevenue
firebase_exp_131id13.5.31.0
firebase_exp_130id23.5.31.1

When I calculate % Difference Experiment with baseline but I cannot get valid result

Current solution: 

- Make base table from origin table relationships is ID_AB_Unit:

ID_AB_UnitExperiment_VariantUser_pseudo_idVersionRevenue
firebase_exp_130id23.5.31.0
firebase_exp_130id43.5.31.1

Then calculate base revenue from base table, calculate experiment revenue from origin table -> DIfference revenue. It seem like working but wrong when I filter by version in origin table  

 

Any idea with this situation?