Setting Shifts for analysis of machine data.

[Ibad_Khan]

Hello PBI Community, hope you all are doing good.

I'm working on analysis of Production Machine data.

I have slicer of date by which data is filtered.

I want to show shift wise production, but issue is that Shift B starts from Current date and ends at next date and I want to show it in current date and rest of the graphs should same data in next date .i.e. actual date.

For eg,

Time	Production	Date	Shifts
10:00Am	0	8-Apr-22	Shift A
03:00Pm	15000	8-Apr-22	Shift A
10:00Pm	15001	8-Apr-22	Shift B
06:00Am	25000	9-Apr-22	Shift B	Should be shown on 8-Apr-2022 only for shiftwise production graph. All other graphs should show this data on 9-Apr-2022.

Can any one help me out in this scenario??

Looking forward for some positive responce.

Regards,

Ibad.

@v-zhangti  @DataInsights @amitchandak @ribisht17 

[Ibad_Khan]

Hi @v-kkf-msft , how're you?

Actually there is no error, but issue is that newly added column contains blank value.

[v-kkf-msft]

Hi @Ibad_Khan ,

Could you please share the data for those rows that return blank values? That would help us find the problem faster!

Best Regards,
Winniz

[amitchandak]

@Ibad_Khan , Assuming shift name is unique. You need a new column like this for that

Minx(filter(Table,[Shifts] =earlier([Shifts])),[Date])

[Ibad_Khan]

Hello @v-kkf-msft , can you share your email?

I'm unable to attach excel  sheet here...

[v-kkf-msft]

Hi @Ibad_Khan ,

Our policy does not allow direct email communication with clients. And if your file contains sensitive data, then it is not recommended that you share it out. Please try to replace these sensitive data with messy words to prevent information leakage. 

Then you can use tools like SharePoint Online to share files that don't contain sensitive data. Or you can take a screenshot and then smear the sensitive data.

Best Regards,
Winniz

[Ibad_Khan]

It's Returning First date of my dataset.

@amitchandak 

[v-kkf-msft]

Hi @Ibad_Khan ,

In my example data, the formula using @amitchandak was able to return the correct results. Could you please share a screenshot of your error results or a PBIX file that does not contain sensitive data?

Best Regards,
Winniz