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 o...
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. 

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.