Forum Discussion
Alternating values based on two columns
Hi Everyone,
I want a column to give alternating values. Consider this as an example.
3 columns- ECN_ID, LogDate, LogTime
The min time entry for each employee each date will be "in" and max time entry will always be "out". Incase the count of rows is even then it should check if the previous entry is "in" then return "out", if "out" return "in". Incase of odd count of rows, it should do the same thing except keep the second last row also "odd".
I have created a measure to achieve this and it is working fine, just the alternate values part is not working.
This is the measure that I have used.
1 Reply
Your sample data is insufficient. Log Time needs to indicate AM/PM. Include at least one other ECN_ID
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
