Generating the data for a report using different dates and different timings

[Anonymous]

I am looking for a report which generates the data for two dates (current and previous day), from morning until 5 PM it should pick previous date data and from the evening 5 PM, it should pick current day date data. I'm using Oracle SQL, Can someone help me how to figure this out?

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Anonymous ,

For your requirement, I think you could achieve that with measure in power bi.

Do you have the date time column in your table model?

If it is convenient, could you share some sample data which could reproduce this scenario and your desired output so that we could give further help on it?

Best Regards,

Cherry

[Anonymous]

I got it resolved but not with measured column. I wrote a query while extracting the data from the database.