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,
I have the following data as shown in the attached photo:
As can be seen format of creation date is DD.MM.YYYY HH.MM.SS . I would like to change it to DD.MM.YYYY, but cannot use FORMAT with direct queries (Add Column).
Is there another ay of doing this in PowerBI or does it need to be changed on the SQL side?
br
Stian
Solved! Go to Solution.
Hi Stian,
You can change it in the Modeling menu in the ribbon.
Best Regards,
Dale
Hi @stibra,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hi Stian,
You can change it in the Modeling menu in the ribbon.
Best Regards,
Dale
The menu options shown here are not available for Direct Query columns - is there another way of formating a date field from a Direct Query.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |