Missing Data (Time)

[DannyAlfa]

Hi all,

I have appended a data set using 2 files with exactly the same columns, data is pulling through as I can see it has updated revenue/sales etc however I have a table that provides a view of timings, I can see timings in the table until it gets to the data where the new apended data began.

I have checked the measures im using and they havent changed and also checked the data format in both data sets and they are identical, any ideas what could be causing the issue??

[Anonymous · Accepted solution]

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. 

[Thejeswar]

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,

[DannyAlfa]

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.

[Thejeswar]

@DannyAlfa ,

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,

[DannyAlfa]

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