Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 trying to achieve:
My datasets available (I may be linking the wrong sets? - Hope this is descriptive enough to follow)
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 trying to achieve:
My datasets available (I may be linking the wrong sets? - Hope this is descriptive enough to follow)
Please delete - somehow got posted twice! Thanks.
Link to other post: https://community.powerbi.com/t5/Desktop/New-User-Using-a-calculated-measure-between-different-table...
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).
Am I doing my measurements incorrectly?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |