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.
Hi, Im trying to create my own calendar table but noticed that most of my data reports uses this format for Month "1/1/2020, 2/1/2020, 3/1/2020. Is there a way for me to capture the month of a specific date to align with the formatting some of my data sources use?
Solved! Go to Solution.
Hi @Lobs ,
In your calendar table, create a new column and enter:
startOfMonth = STARTOFMONTH(cal[date])
This should give you what you need.
Pete
Proud to be a Datanaut!
hi @Lobs - you should be able to format your date as "m/d/yyyy" in the data view in Power BI desktop
You can derive the month name and month number as seen below
OR if you want to retain your original format on the Date column, you can create a new calculated column for the required format
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
Hi @Lobs ,
In your calendar table, create a new column and enter:
startOfMonth = STARTOFMONTH(cal[date])
This should give you what you need.
Pete
Proud to be a Datanaut!
Thank you this worked 🙂
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |