Date Format - not working

[Anonymous]

Hello,

help! I am driving crazy 😞

There is no way I can format the date to be able to work with months or quarters.

When I choose "Transform data" apparently the field "Invoice date" was turned into a Date Format.

but then, When I go to the report to bring "invoice date" into a column chart for instance, the field is not formated as "date" as you can see in both images below.

Could you please help me? What I am doing wrong?

[Idrissshatila]

Hello @Anonymous ,

Create a dimension Date table that has all the columns needed for your analysis and link it to the date in your fact table.

check how to do it https://youtu.be/BnqtBxGbo0M?si=raecZw1_xCUStahq

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡