Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 have a One to Many relationship between the Calendar table and both the StoppageData and OeeData table. StoppageData is presenting itself correctly, but OeeData (AutoTime) is incorrect. Removing StoppageData relation doesnt change anything.
Date format on OeeData and StoppageData is identical.
Relationsships are One to Many from the calendar i am using.
Solved! Go to Solution.
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.
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.
I appreciate any help with this issue.
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |