Forum Discussion

ZZZZZZZ37's avatar
ZZZZZZZ37
Frequent Visitor
3 years ago

SELECT VALID DATE USING POWER BI DAX

Hi Power BI Community,    Disclaimer: New to Power BI and learning is still in progress.   My Team and I are working on some date to filter the schedule of employees. We are checking the log out ...
Need Help
Tips and Tricks
tutorial request
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

ZZZZZZZ37 , Based on what I got

 

new column =

var _max = maxx(filter(Table, [User] = earlier([User]) && [Schedule Date] = earlier([Schedule Date]) && && [Schedule Start Time] = earlier([Schedule Start Time])  && && [Schedule End Time] = earlier([Schedule End Time]) && [Case] = "Out") ,  [attendance out])

var _count= maxx(filter(Table, [User] = earlier([User]) && [Schedule Date] = earlier([Schedule Date]) && && [Schedule Start Time] = earlier([Schedule Start Time])  && && [Schedule End Time] = earlier([Schedule End Time]) && [Case] = "in") ,  [attendance out])

return

if(not(isblank(_cnt) )  && _max = [attendance out], 1, 0 )

 

 

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.