Forum Discussion

ginalu's avatar
ginalu
Helper I
1 year ago

Issue with Missing data in Calculation

Some lessons are included while others are missing in the calculation.  Example of Missing Lesson in Calculation For example, a user conducted a lesson on 10/16. Since today is 10/21, the les...
Need Help
MNedix's avatar
MNedix
Solution Sage
1 year ago

Heya,

I think TRUNC throws a spanner in the works. Could you please try DATEVALUE instead? Also, I don't know your data but are you sure about the last filter argument?

  • ginalu's avatar
    ginalu
    Helper I
    1 year ago

    Hi MNedix 

    Thank you for your reply. I tried it, but it still missing in the calculation.

    • MNedix's avatar
      MNedix
      Solution Sage
      1 year ago

      Hi,

      Could you please split in Power Query the start_time column by delimiter? Try to isolate only the date portion of that column, I remember it helped me in the past. Then adjust the calculation accordingly.