Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I want to write a measure that counts the number of cancelled events when the difference between the cancelled date of the event and the actual start date of event is less than 24 hours. I have some data inclusion filters that are applied at the page level. I want the measure to calculate the cancelled event on inclusion data only. The date data looks like as follow:
Cancelled Date has a default value of '1/01/1900 1:00:00 pm' which means no cancellation date. I wanted to calculate the no of events that have cancelled date. So my measure is as follow:
Data can be download from here
Solved! Go to Solution.
@Dunner2020 , Create a measure like
calculate(countrows(Table), filter( Table, datediff(Table[Cancelled Date ],Table[Actual Interruption Start Time],hour)<24))
@Dunner2020 , Create a measure like
calculate(countrows(Table), filter( Table, datediff(Table[Cancelled Date ],Table[Actual Interruption Start Time],hour)<24))
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |