Create ID for each weekday time1 and time2 based on the sample data

Question

Hi ,&nbsp;I need some help as the ID is working for all weekdays but not for friday.&nbsp;&nbsp;Sample data google drive linkhttps://docs.google.com/spreadsheets/d/1kMgzehh1inILMJ7VA-EuHR36vsv53JcO/edit?usp=drive_link&amp;ouid=107322499030709606985&amp;rtpof=true&amp;sd=true&nbsp;&nbsp;&nbsp;

dufoq3 · Answer

You are not reading properly...

bhaskarpbi999 · Answer

Hi Dufo,Current source data has 3 columns Index, Date, time like below&nbsp;&nbsp;Expected output is 4th custom column ID need to created and time1 and time 2 values needed for each weekday.&nbsp;&nbsp;Attaching source sample data with below link and sorry for the trouble caused by me.&nbsp;Sample Data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

dufoq3 · Answer

You're still repeating the same and not reading. In previous post you have a link with solution.

bhaskarpbi999 · Answer

Hi Dufo,I have link and the solution is working for All days except friday where it is displaying time1 and time1 instead of Time2 that is the only issue.&nbsp;Thanks for your whole hearted support.Kudos any tricks please help me.&nbsp;Regards,Bhaskar&nbsp;

bhaskarpbi999 · Answer

&nbsp;

Forum Discussion

Create ID for each weekday time1 and time2 based on the sample data

5 Replies

Related content

Sample unification

Create Sample Size in DAX

Average $ per weekday

AdventureWorks Sample

Weekend and Weekday Analysis