Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I'm working with the dataset below, which contains a StartDate column. The source file's StartDate column was initially formatted as Jan 2024, Feb 2024. However, when extracted into Power Bi, I modified the date format by highlighting the "StartDate" column and then selecting "Data Type Text" under the Transform ribbon, followed by date, to convert the Startdate format.
I would want to use the StarDate field to add an EndOfMonth column.
Thank You!
Solved! Go to Solution.
Hi @Anonymous,
Insert a custom column and enter this in the formula area:
Date.EndOfMonth([StartDate])
I hope this is helpful
Hi @Anonymous,
Insert a custom column and enter this in the formula area:
Date.EndOfMonth([StartDate])
I hope this is helpful
User | Count |
---|---|
7 | |
5 | |
5 | |
5 | |
4 |
User | Count |
---|---|
11 | |
11 | |
9 | |
7 | |
6 |