Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
In our Daily report we calculate our production from the production which has happened from 8:30 AM 01/01/2021 to 8:29 AM 02/01/2021 on the next Day as the production figures. But when we make it in BI and select the date of 01/01/2021, system will show us the production from 12:00 AM 01/01/2021 to 11:59 PM 01/01/2021.
Is there any way to formulate or calculate hat when we select date os 01/01/2021, system calculates from 8:30 AM 01/01/2021 to 8:29 AM 02/01/2021?
Faisal
Also you might need to create a measure to filter the production time, make it between the start time and endtime.
Not sure how did you record your data. It would be more clear if you can share a sample and expected output in table.
Regards
Paul
Hi @MK_Process
You could create an additional calculated column in your fact table that assigns the date as you want it shown, i.e. if datetime in that row is 01/01/2021 8:00 AM the result for that column will be 12/31/2021 but for 01/01/2021 8:30 AM it will be 01/01/2021 and so forth.
Then create a relationship between you date table and that newly created column
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.