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.
Hi,
I have this dataset for example:
Hotel | Day | Price |
A | 1 | € 150.00 |
A | 1 | € 130.00 |
A | 1 | € 200.00 |
B | 1 | € 150.00 |
C | 1 | € 145.00 |
C | 1 | € 135.00 |
D | 1 | € 200.00 |
D | 1 | € 190.00 |
A | 2 | € 190.00 |
B | 2 | € 160.00 |
B | 2 | € 120.00 |
C | 2 | € 120.00 |
C | 2 | € 178.00 |
D | 2 | € 170.00 |
So for each day I have Hotels with different prices (different rooms). What I want to do is to calculate the average by hotel of their lowest rate. First calculate the MIN value for each hotel by day and then create the average of those days (in this example day 1 and 2. So then I can have a graph like this:
Or maybe create a column that only return the lowest price for each hotel and the other rows return 0, and then I can create an average of that column excluding zeros.
I have tried a lot of calculations but none of them seem to work. Can you help me with this?
Thank you!
Manuel Banza
Solved! Go to Solution.
Try this:
Try this:
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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |