Good Morning to everyone from Italy
apologize for my bad English
i ask for a help or a suggestion.
at the end of every month i export from my datawarehouse to Excel two tables with sales information that i use to create reports for my CEO.
Now i'm starting to use PowerBI but and i'm a little bit in trouble with the concept of DATE
i would like to create a calendar table but here's my problem:
the colum Year and Month are text formatted.
how i can convert to date format ?
is possible ?
Go to Solution.
You can add a New Column for example
DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )
View solution in original post
Write this calculated column formula
Format this column as Date.
thanks to all of you for your kindly answers, both working.
last question, if i create a new table "Calendar" with the function "CALENDARAUTO ()" I obtain an error
message "the function is not able to find a base column DateTime in the model"
i dont understand well why i obtain this error
Regard from Italy
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!