Forum Discussion
Missing Data (Time)
Hi DannyAlfa ,
Thanks Thejeswar for the quick reply. I have some other thoughts to add:
(1) There is a hotel name column in your expected results that does not exist in your data, where I have added the hotel name column to the test data.
(2) Create a time column.Time = TIMEVALUE([Date])(3)Create measures.
Min time = CALCULATE(MIN('Table'[Time]),FILTER(ALL('Table'),'Table'[Hotel Name]=MAX('Table'[Hotel Name])))Max time = CALCULATE(MAX('Table'[Time]),FILTER(ALL('Table'),'Table'[Hotel Name]=MAX('Table'[Hotel Name])))If I have misunderstood you, please clarify in a follow-up reply.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi DannyAlfa ,
With the info that you have given it is quite difficult to say any reason for this.
You need to check
how the timings data is flowing in?
Does the source of the timings table have the right data?
is that related in any way to this new updated data?
Is the new data impacting the timing table?
Could be anything of the above reasons. Potentially there can be many other reasons for this.
One simple hack would be to drop the timings table and recreate the timings table. You need to take a call on how expensive this can be in your case before doing this
Regards,
Thanks for your respose,
I have reset the timings table using the same 2 measures I had before: -
Max Time = FORMAT(MAXX('Till Data_v2','Till Data_v2'[Time]), "HH:mm:ss")Min Time = FORMAT(MINX(FILTER('Till Data_v2','Till Data_v2'[Time] < TIME(2, 0, 0) || 'Till Data_v2'[Time] > TIME(11, 59, 0)), 'Till Data_v2'[Time]), "HH:mm:ss")The only other field in the table is the Subject Name which is exactly the same. I have conditional formatting on both Min Time & Max time so it shows a specific colour based on the value and that is identical also.Can you share some sample dummy data from the table that you are using to get the timing table? It would be great if you also can share the expected output for the data set that you are sharing in the timing table
Regards,
Thanks Thejeswar I have attached a dummy data set, within this dataset I have added columns within excel to split Date & Time and added a field to give me the day of the week also.
The output should look like the below (Tills down the left): -Date Receipt number Receipt type Category SKU Item Variant Modifiers applied Quantity Gross sales Discounts Net sales Cost of goods Gross profit Taxes POS Store Cashier name Customer name Customer contacts Comment Status 21/10/2024 23:35 103-99999 Sale BAR SNACKS 12345 Crispy Chips 50g BBQ None 1 1.5 0 1.5 0.75 0.75 0.25 Bar A Hotel A John Doe Jane Smith 123-456-7890 N/A Closed 21/10/2024 23:30 50-12345 Sale DRAUGHT BEERS 67890 Lager Pint Regular None 1 5 0 5 2.5 2.5 0.8 Bar B Hotel B Jane Roe Mike Lee 987-654-3210 N/A Closed 21/10/2024 23:25 76-54321 Sale SOFT DRINKS 13579 Cola 200ml Diet None 2 3 0 3 1.2 1.8 0.5 Bar C Hotel C Sam Smith Clara Johnson 555-123-4567 N/A Closed 21/10/2024 23:20 103-88888 Sale PREMIUM SPIRITS 24680 Premium Whiskey 50ml Double None 1 8 0 8 3 5 1.2 Bar D Hotel D Alex King Rick James 222-333-4444 N/A Closed 21/10/2024 23:15 82-77777 Sale HOUSE SPIRITS 97531 Vodka 50ml Single Lemon Slice 1 6.5 0 6.5 2 4.5 0.9 Bar E Hotel E Chris Brown Sarah Connor 444-555-6666 N/A Closed
