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.
I have a table of actual property bookings and a table of planned property bookings.
I want to show how we are doing on actual sales compared to plan. A simplified example of my two source tables and the one desired comparison table is below.
I cannot figure out how to create a table that will do this. Can anyone point me in the right direction or show me what DAX concepts I need... If it is very simple I would graciously and thankfully be happy to just have the code to get this done. Any help is appreciated.
Thanks
TAble 1 - Booked Dates
Booked Dates Booked Property Sales Channel
1/3/2018 ocean side A
1/4/2018 ocean side A
1/5/2018 ocean side A
3/1/2018 sloap side B
3/2/2018 sloap side B
3/3/2018 sloap side B
Table 2 - Planned Dates
Dates Planned Property Sales Channel
1/1/2018 ocean side B
1/2/2018 ocean side B
1/3/2018 ocean side B
1/4/2018 ocean side B
3/1/2018 beach side A
3/2/2018 beach side A
4/1/2018 city side C
Table 3 Booked Vs Planned
Month Property Planned Booked Channel Planned Channel Booked
January ocean side 4 3 B A
March beach side 0 2 0 A
April city side 0 1 0 C
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |