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.
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 ?
Thanks
Solved! Go to Solution.
You can add a New Column for example
Column = DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )
Hi,
Write this calculated column formula
=1*("1/"&[MonthNumber]&"/"&[Year])
Format this column as Date.
Hi,
Write this calculated column formula
=1*("1/"&[MonthNumber]&"/"&[Year])
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
Matteo
You can add a New Column for example
Column = DATE ( VALUE ( [Year] ), VALUE ( [MonthNumber] ), 1 )
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |