Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
How can I convert the following to a measure?
Column =
COUNTROWS( (
FILTER (
schedule,
schedule[start_date] <= EARLIER ( [Date] )
// && schedule[end_date] >= EARLIER ( [Date] ) && schedule[no. of attachments] <> 0
&& schedule[end_date] >= EARLIER ( [Date] ) && schedule[no. of attachments] > 0
&& schedule[type] = "Appointment"
)
))
Solved! Go to Solution.
@pieduke88 Try:
Column =
VAR __Date = MAX('Dates'[Date])
VAR __Result =
COUNTROWS(
FILTER (
ALLSELECTED(schedule),
schedule[start_date] <= __Date
&& schedule[end_date] >= __Date && schedule[no. of attachments] > 0
&& schedule[type] = "Appointment"
)
)
@pieduke88 Try:
Column =
VAR __Date = MAX('Dates'[Date])
VAR __Result =
COUNTROWS(
FILTER (
ALLSELECTED(schedule),
schedule[start_date] <= __Date
&& schedule[end_date] >= __Date && schedule[no. of attachments] > 0
&& schedule[type] = "Appointment"
)
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
172 | |
108 | |
105 | |
71 | |
70 |