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.
I'm brand new to Power Bi and I'm running into an issue due to lack of knowledge. I've searched online but to be honest I dont even know what I should be search for. My issue is I have a column from an auto-generated report with start dates for my work (they go back to the 80's) the format is in short date (3-Nov-20). Is there away of using Power Bi to break those out into months and years ?
Solved! Go to Solution.
@EdM1980 there are a few approaches! You can create the columns in Transform Data, or as measures in the table, or introduce a Date table to your model (creating a relationship between the Date table and your date column). in all scenarios, it's important your date column is properly changed to a Date datatype.
For the calculated columns you can use:
Month = DATE ( YEAR ( [Date] ), MONTH ( [Date] ), 1 )
Year = DATE ( YEAR ( [Date] ), 1, 1 )
Then you can format it to look like a month or month (instead of a date). Bonus here is it sorts properly.
To create the date table, you go to Modeling -> New Table and use the following DAX:
Then create a relationship between the tables on dates.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
@EdM1980 there are a few approaches! You can create the columns in Transform Data, or as measures in the table, or introduce a Date table to your model (creating a relationship between the Date table and your date column). in all scenarios, it's important your date column is properly changed to a Date datatype.
For the calculated columns you can use:
Month = DATE ( YEAR ( [Date] ), MONTH ( [Date] ), 1 )
Year = DATE ( YEAR ( [Date] ), 1, 1 )
Then you can format it to look like a month or month (instead of a date). Bonus here is it sorts properly.
To create the date table, you go to Modeling -> New Table and use the following DAX:
Then create a relationship between the tables on dates.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
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 |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |