Forum Discussion
deasine
7 years agoNew Member
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...
deasine
7 years agoNew Member
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:
- Graph of Average Transactions Per Customer by Month i.e. [2-4]/[1-2] for each Month (MMM) along X-axis
- Graph of Average Reveue Per Customer by Month i.e. [2-5]/[1-2] for each Month (MMM) along X-axis
My datasets available (I may be linking the wrong sets? - Hope this is descriptive enough to follow)
- Customers:
- Month-Year (in MMM-YY)
- Customers (Total customers per month)
- Transactions and Revenues
- Transaction Start Date/Time (in DD/MM/YY HH:MM format)
- Transaction End Date/Time (in DD/MM/YY HH:MM format)
- Transaction Duration
- Transaction Unit (all transactions set as 1)
- Total Revenue of the corresponding transation
- Dynamic DAX Calendar (self created)
- Date (DD/MM/YY format) - This is linked to 2-1 above
- YearPeriod (YYYYMM format based on date)
- Month (MMM format based on date) - This is linked to 1-1 above
- MonthYear (MMM-YY format based on date)
deasine
7 years agoNew Member
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-tables/m-p/630126