Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |