Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi. I have a problem with dates. I have a column called plstart, this contains decimal numbers. This tells when a detail should start to be produced. This is connected to a workplace-table which is connected to a calendar-table. This calendar contains similar columns with numbers but no one is exact. "Planned start time in relative time depending on calendar" it says as a comment. How do I?
Solved! Go to Solution.
Hi @Bergh ,
Based on your description, it seems that you want to connect the timestamp-like column plstart in the Workplace table with the retime column in the Calendar table. But the problem is that the column plstart does not have exactly the same information as retime, so you may not get the data. Am I understanding this correctly? Please correct me if it is not correct. Also, could you please share some sample data withText format (exclude sensitive data) and the final result you want in order to analyze and provide you with a suitable solution.
1. Sample data with Text format
Col1 | Col.. | Colx |
xx | xx | xx |
xx | xx | xx |
2. Your expected result?? A table visual or something else?
Best Regards
Hi @Bergh ,
Based on your description, it seems that you want to connect the timestamp-like column plstart in the Workplace table with the retime column in the Calendar table. But the problem is that the column plstart does not have exactly the same information as retime, so you may not get the data. Am I understanding this correctly? Please correct me if it is not correct. Also, could you please share some sample data withText format (exclude sensitive data) and the final result you want in order to analyze and provide you with a suitable solution.
1. Sample data with Text format
Col1 | Col.. | Colx |
xx | xx | xx |
xx | xx | xx |
2. Your expected result?? A table visual or something else?
Best Regards
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |