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 want to add 2 filters onto a measure.
I have a table with reservations records that have date fields for "Arrival date" and "Booking date"
This table is linked to a calendar table via an active relationship between "Date" and "Arrival date"
I want to compare current period revenue with prior period revenue, but exclude reservations in my prior year comparative that have a booking date within 1 year of the last current booking date (in other words, to compare with where we are now, with where we were at the same date this time last year)
I wanted to use the following measure, but it shows as bank on my visualization:
The measure [Total Revenue] within this formula is:
Hi Maggie,
What format is your date in? MM/DD/YYYY?
Basically, if the last booking date in my data is 10 April 2018, then bookings with a booking date greater than 10 April 2017 should be excluded from the comparitive figure.
The logic is that at the same point in time one year ago, those bookings had not yet been made, so I want to have a fair comparison.
Thanks!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |