Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am experiencing an issue when trying to calculate the revenue for a given business day. Here is an example of what timeframe constitutes a business day:
8/7/2022 4:00am - 8/8/2022 3:59AM - This would be for business day 8/7/2022.
The data i am working with is all labeled by calendar day. The data also has a column for hour which i believe should prove to be helpful. My issue is that i do not know how to manipulate my DAX to give me the revenue for my business day and label it with the correct day.
Here is an example of the data i am working with:
Here is the query i am using which works if my business day aligned with the calendar day:
@Fulfilled , Refer if this blog can help
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
29 | |
27 | |
24 | |
22 |