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.
Hi, when I connect a SQL server into Power BI, the date field(set as yyymmdd, es 20180102) becomes a SUM.
Pls can you help me?
How can I change it and to have it like a date, and not like a sum of numbers?
Solved! Go to Solution.
Hi @Andrea78m,
Add a new calculated column.
Column2 = LEFT ( Table2[Column1], 4 ) & "/" & RIGHT ( LEFT ( Table2[Column1], 6 ), 2 ) & "/" & RIGHT ( Table2[Column1], 2 )
Best regards,
Yuliana Gu
Hi @Andrea78m,
I think the date values which is formatted as "20180102" is recognized as whole number. The highlighted symbol ponits that the data type is number. So, please change the data type to "Date" in the ribbon.
Best regards,
Yuliana Gu
Unfortunately it gives me error
Maybe I'd modify the query in power BI?
Do you habe others idea to solve it?
Hi @Andrea78m,
Add a new calculated column.
Column2 = LEFT ( Table2[Column1], 4 ) & "/" & RIGHT ( LEFT ( Table2[Column1], 6 ), 2 ) & "/" & RIGHT ( Table2[Column1], 2 )
Best regards,
Yuliana Gu
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 | |
106 | |
87 | |
74 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |