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.
Dear friends
please suggested me how i create max break in 1 day column that saying max break value individual by day, details as table below
Date | Name | Break time | Max break time in 1 day |
01-01-20 | John | 6:00 | |
01-01-20 | Jame | 5:00 | 5:00 |
01-01-20 | John | 2:00 | |
01-01-20 | John | 8:00 | 8:00 |
01-01-20 | Jame | 1:00 | |
02-02-20 | Jame | 3:00 | |
02-02-20 | Jame | 7:00 | 7:00 |
02-02-20 | John | 4:00 | 4:00 |
02-02-20 | John | 2:00 |
Can any one please suggest me.
Thanks
Solved! Go to Solution.
@Anonymous
Try below DAX in a calculated column
MaxBreak =
VAR __maxTime =
MAXX (
FILTER (
'Table',
'Table'[Date] = EARLIER ( 'Table'[Date] )
&& 'Table'[Name] = EARLIER ( 'Table'[Name] )
),
'Table'[Break time]
)
VAR __result =
IF ( 'Table'[Break time] = __maxTime, __maxTime, BLANK () )
RETURN
__result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
@Anonymous , Try like
if([break time] =maxx(filter(table, [name]=earlier([name]) && [date]=earlier([date])),[break time]) ,[break time],blank())
@Anonymous
Try this as measure:
Measure =
VAR BT =
CALCULATE(
MAX('Table'[Break time ]),
ALLEXCEPT('Table', 'Table'[Name ],'Table'[Date ]))
RETURN
IF( BT = MAX('Table'[Break time ]),FORMAT(BT,"hh:mm"),"")
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Try this as measure:
Measure =
VAR BT =
CALCULATE(
MAX('Table'[Break time ]),
ALLEXCEPT('Table', 'Table'[Name ],'Table'[Date ]))
RETURN
IF( BT = MAX('Table'[Break time ]),FORMAT(BT,"hh:mm"),"")
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous , Try like
if([break time] =maxx(filter(table, [name]=earlier([name]) && [date]=earlier([date])),[break time]) ,[break time],blank())
@Anonymous
Try below DAX in a calculated column
MaxBreak =
VAR __maxTime =
MAXX (
FILTER (
'Table',
'Table'[Date] = EARLIER ( 'Table'[Date] )
&& 'Table'[Name] = EARLIER ( 'Table'[Name] )
),
'Table'[Break time]
)
VAR __result =
IF ( 'Table'[Break time] = __maxTime, __maxTime, BLANK () )
RETURN
__result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
@nandu_krishna nice solution, i have another question what if i need to show "Need a break" instead of show max break in Max break in 1 time column what should i do cause i just try to adjust your dax like below but its go wrong.
@Anonymous
In your DAX, I could see that you are not returning the __result variable.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |