Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am getting the followin error:
I don't what's the issue. The source columns for this calculated column has no errors and is in proper type.
Solved! Go to Solution.
Thank you very much, guys!
The types were OK.
I tried different formats yesterday, none worked. I resolved the issue by finding a null value in the dataset.
I asked the responsible employee to fix it and it worked.
Hi @Birdjo,
There existing a date type column and time column in table 'Logs', right? After loading data into desktop, the time column will be converted to date/time automatically. You can check this in Query Editor mode. Please first change its data type to "Time".
Then, you could use the CONCATENATE function to combine two columns. Remember to change the data type of [Entry datetime] from Text to Date/Time.
Best regards,
Yuliana Gu
Thank you very much, guys!
The types were OK.
I tried different formats yesterday, none worked. I resolved the issue by finding a null value in the dataset.
I asked the responsible employee to fix it and it worked.
I think you want to use the FORMAT DAX function to convert the date into a text. You can see more about it here.
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |