Forum Discussion
Divide two columns from different tables
Hello everyone, currently I have two tables: table 1 and table 2 in Power BI
Table 1:
Date | Column A |
01/01 | 120 |
02/01 | 34 |
03/01 | 90 |
04/01 | 109 |
Table 2:
Date | Column B |
01/01 | 200 |
02/01 | 103 |
03/01 | 270 |
04/01 | 300 |
These tables are made in Power BI after I dragged two fields for each one.
For table 1, they are the "Date" column and column A (which is the count of "True" values for each day).
Date | Column C |
01/01 | True |
01/01 | False |
01/01 | True |
02/01 | True |
03/01 | True |
03/01 | True |
04/01 | True |
04/01 | False |
04/01 | False |
Table 2 is made by counting the number of clicks for each day
What I want to do is: Column A divided by Column B (A/B for short) for each day and I will use that result to draw a graph. What can I do to achieve this?
Thanks for your help!
Anonymous
you can create a date table and create relationships with table 1 and table 2
Then create a measure
Measure = VAR _1=CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[ColumnC]=TRUE())) VAR _2=sum(Table2[click]) return _1/_2pls see the attachment below
8 Replies
Anonymous
you can create a date table and create relationships with table 1 and table 2
Then create a measure
Measure = VAR _1=CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[ColumnC]=TRUE())) VAR _2=sum(Table2[click]) return _1/_2pls see the attachment below
Hi Anonymous ,
You can use measureMeasure = DIVIDE(SUM('Table A'[Column A]),SUM('Table B'[Column B]))