Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
The created column in SharePoint is a Date / Time field and when brought into Power BI is seen as a text field rather than a date field. How can you filter on date such as After 2022-09-01 since it isn't seen as a date? Do I need to to a measure or transform to create a calculated column?
Solved! Go to Solution.
Replying to myself in case it helps someone else later. Select the column on the far right list. Then at the top change the data type from text to date. Once this is done you can now filter it like a standard date field. Once I figured it out super easy.
Hi @hoyty,
To filter on date you can create a calculated column to convert the text field to a date field. Here's how you can do it:
Open the Power Query Editor in Power BI by clicking on "Transform Data" in the Home tab of the ribbon.
Select the table that contains the "Created" column.
Right-click on the "Created" column and select "Change Type" > "Using Locale" > "Date/Time".
If the column contains any errors, Power Query will prompt you to correct them.
Once the "Created" column is converted to a date/time data type, click on "Close & Apply" to save the changes.
Now you can create a calculated column by clicking on "New Column" in the Modeling tab of the ribbon.
Use the following formula to create a calculated column that extracts the date from the "Created" column:
= DATE(YEAR([Created]),MONTH([Created]),DAY([Created]))
Name the calculated column "Created Date" or something similar.
Now you can use the "Created Date" column to filter your data by date, such as filtering for dates after 2022-09-01.
By creating a calculated column that extracts the date from the "Created" column, you can now filter your data based on date values.
Best regards,
Isaac Chavarria
If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly.
Thanks, the method I found was way easier. Yours might work with dirty data.
Replying to myself in case it helps someone else later. Select the column on the far right list. Then at the top change the data type from text to date. Once this is done you can now filter it like a standard date field. Once I figured it out super easy.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |