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,
Below is my model .My "appointment" table has details like when appointment is scheduled(column schedulestart) while in "activity parties" i have account names for which appointment is scheduled(column Account name).they have 1-many relation based on account id(appointments) and partyid(activity parties)
I am showing data in a table as below.My requirement is to highlight Account name and start time columns if a meeting is happening for a same account in next 15 days(fortnight).
@Anonymous
Add a calculated column and take advantage of Apply conditional table formatting.
Column =
VAR a = 'Table'[Account]
VAR t = 'Table'[start time]
RETURN
IF (
ISEMPTY (
FILTER (
'Table',
'Table'[Account] = a
&& DATEDIFF ( t, 'Table'[start time], DAY ) > 0
&& DATEDIFF ( t, 'Table'[start time], DAY ) < 15
)
),
0,
1
)
hey @v-chuncz-msft thanks for you reply ..It should also return 1 for date 2/4/2020.. as its within 15 days for same account
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |