Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have two tables with approx 1 million rows. Each table includes data from Jan 2018 until Present. The "Count of Fees Waived" column is based on daily inputs.This data includes site and Agent. The "Calls Handled data" is based on monthly inputs, it includes site but does not include agent. I am trying to calculate Monthly Count of Fee Waiver rates as a percentage of Monthly Calls Handled. I tried to create a new measure to calculate "Monthly Fee Waiver Rates" and when I view this new measure by month the calculation is way off, it is extremely low. I believe it has something to do with my "Count of Fee Waivers" data being daily while my "calls handled" data is monthly. I also tried to establish a relationship between the two tables but this did not work. My end goal is to include the Monthly Count of Fee Waiver rates in a chart that allows me to drill down to site level and agent level. Can anyone help me?
Months | Site | Calls Handled |
Jan | stanton | 9113 |
Jan | overtown | 9698 |
Jan | kingston | 3515 |
Jan | linstead | 10810 |
Jan | mabelton | 13045 |
Date | Site | Agent id | Count of Fee Waivers |
1/1/2018 | stanton | abcd | 2 |
1/2/2018 | overtown | adsdsd | 6 |
1/3/2018 | mableton | dsfsf | 1 |
1/4/2018 | linstead | sds | 9 |
1/5/2018 | burchell | asasa | 1 |
Solved! Go to Solution.
You will need a relationship between the two based on Site. To do this, create a bridge table like:
Table = DISTINCT('Table'[Sites])
Alternatively, you could create a column in each table like this:
Column = CONCATENATE([Months],[Site]) Column = CONCATENATE(FORMAT([Date],"mmm"),[Site])
And use those as your relationship.
You will need a relationship between the two based on Site. To do this, create a bridge table like:
Table = DISTINCT('Table'[Sites])
Alternatively, you could create a column in each table like this:
Column = CONCATENATE([Months],[Site]) Column = CONCATENATE(FORMAT([Date],"mmm"),[Site])
And use those as your relationship.
Greg Deckler..Thank you very much that did the trick
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |