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 all,
I have a table with date and time. I want to exlude the rows with time = 00:00:00 to compute the max Occupation.
I've written a mesure that gives the maximum occupation but with time = 00:00:00 included
************************************
Thank you
Solved! Go to Solution.
Hi @khalidjou
You can try this measure
Max_occup =
VAR Datum =
DATE ( [max_Année]; [max_month]; [max_jour] )
VAR Bi =
CALCULATE (
MAXA ( tblname[Occupation] );
tblname[Date] = Datum;
TIMEVALUE ( tblname[Date] ) <> TIME ( 0; 0; 0 )
)
RETURN
Bi
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @khalidjou
You can try this measure
Max_occup =
VAR Datum =
DATE ( [max_Année]; [max_month]; [max_jour] )
VAR Bi =
CALCULATE (
MAXA ( tblname[Occupation] );
tblname[Date] = Datum;
TIMEVALUE ( tblname[Date] ) <> TIME ( 0; 0; 0 )
)
RETURN
Bi
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@khalidjou , You need like
new meausre =
CALCULATE(MAXA(tblname[Occupation]);filter(allselected(tblname) , tblname[Date]=max(tblname[Date]) && timevalues([tblname[Date]) <> time(0,0,0)))
or only date part of the date
Only date column = datevalue([Date])
new meausre =
CALCULATE(MAXA(tblname[Occupation]);filter(allselected(tblname) , tblname[Only Date]=max(tblname[Only Date]) && timevalues([tblname[Date]) <> time(0,0,0)))
Thank you Amitchandak,
Another question please. When I finf the Max occupation, how can I get the corresponding date ?
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 |
---|---|
171 | |
110 | |
109 | |
73 | |
71 |