Forum Discussion
Measure for calculating appointments
Hi Anonymous ,
Please try:
Rolling 6 =
CALCULATE (
CALCULATE (
[TEST],
FILTER ( 'Appointment', 'Appointment'[Booking date] <= MAX ( 'Calendar'[Date] ) )
),
DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Calendar'[Date] ), 6, MONTH )
)Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Anonymous I get the same result with this measure. The value for January 4th, for example, should be '942'. The booking date should not be larger than the 'row date' that is displayed in the table (which comes from Calendar[Date]). Any ideas?
Hi Anonymous ,
I would first consider the relationship, can 'Appointment'[Booking date] be filtered by 'Calendar'[Date]?
Would you mind providing some sample files that do not contain sensitive data? It would be helpful to find out why, thanks in advance!
How to provide sample data in the Power BI Forum
Best Regards,
Gao
Community Support TeamAnonymous Please find a sample file here: PBI sample file
Hi Anonymous ,
The formula output is correct. Does your expected output need to consider de-duplicating the count of the results? This may be the reason for the larger result. Please check this file. The latter output is the result of considering the de-duplication.
If I misunderstood your needs, you could pick a date and demonstrate the calculation process and output based on this file, thanks in advance!
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data