Forum Discussion

lukasjar's avatar
lukasjar
Resolver I
6 years ago
Solved

Calendar date relations returns blank?

  Hello community! I cannot find the reason to why the table below is not identifying the correct Year for the columns AutoTime,RunTime... As you can see on the pictures for table relationsships I...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Your starttime has time stamp

     

    Create a a new column

    Start date = Table[Starttime].date

    Or

    Start date = format(Table[Starttime],"mm/dd/yyyy") //Change data type to date. Use it to join

     

    Appreciate your Kudos.

DavidGolden's avatar
DavidGolden
Helper I
2 years ago

Hello, I have a similar trouble dealing with a column of dates from Table [Fec.Denuncia], wich is related to the Dates (CALENDARAUTO). For some reason that I cannot understand yet, some of the dates in Table[Column] are linked to BLANK values (blanks that I cannot see in Dates!). Since this relation is not active, the counting of elements through CALCULATE when utilizing USERELATIONSHIP return an incorrect result. 

For example, when exploring through Data view, 452 elements are listed in January, 2024, by [Fec.Denuncia]. But when filtering with the related Dates, some of them are missing.

 

See pictures below please, when filtering by [Fec.Denuncia] is the same range as Dates, only 117 of 452 elements are counted, and the remaining 335 elements are seen as blank dates of Date (CALENDARAUTO). I checked formats are of Date type, also that all dates are in Dates. I also tried building a new column from [Fec.Denuncia] but i didnt worked.

Result when BLANK Dates are filtered together with January in ColumResult when all Dates are active

I appreciate any help with this issue.