Forum Discussion
New User: Using a calculated measure between different tables
Hi Everyone, I'm quite new to PowerBI so I'm still trying to get the hang of it. My question is: How we can do a measure between different tables? I can obtain the revenue What I'm try...
Have you joined all the tables by date yet?
Hi nmck86,
I did it through YearPeriod rather than date as my data output on customers was done on a total per month basis (in YearPeriod form).
Somehow, I removed all links and put everything again and it seemed to work, but I ran into another problem. I'm trying to get average transactions/revenue per customer per month, I'm getting weird figures (I did an xlsx check to make sure).
- My [Revenue] is per transaction basis, so I did a Measure = .TotalRevenue = SUM([Revenue]) -
- My original [Revenue] data is a Σ stored as a data type for whole number with $
- This measure was created as I couldn't seem to directly divide revenue/transactions over custome
- My [Customers] is per month basis, so I did a Measure = Sum ([Passengers])
- My customers [customer] data is a Σ stored as a data type for whole number
- This measure was created as I couldn't seem to directly divide revenue/transactions over customer
- Note that this is stored as a separate table dataset from the revenue/trasnactions
- I have another Measure /Total Revenue Per Customer = DIVIDE([.TotalRevenue],[.Total Customers],"N/A"
- For this measure, I couldn't simply divide individual revenues over total customers
- My desired output is to have months across X-axis, transactions/revenue per customer over Y-Axis
Am I doing my measurements incorrectly?