Forum Discussion

DannyAlfa's avatar
DannyAlfa
Frequent Visitor
1 year ago
Solved

Missing Data (Time)

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??

General Comment
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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. 

5 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    1 year ago

    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's avatar
      DannyAlfa
      Frequent Visitor
      1 year ago

      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's avatar
        Thejeswar
        Super User
        1 year ago

        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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.