Forum Discussion
Date Format - not working
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?
1 Reply
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 💡
