Date function for excluding last 3 months along and current month as well

[prvn8887]

I need help to exclude last 3 months data and current month data. Example: as of today I need data till 31st May 2023. Please help it's urgent. Thanks!

[123abc]

In Power BI, you can create a DAX measure to filter and exclude the last 3 months' data along with the current month's data. Assuming you have a date column named "Date" in your data table, you can use the following DAX measure to achieve this:

FilteredData = FILTER ( YourTableName, -- Replace with the name of your data table YourTableName[Date] < DATE(YEAR(TODAY()), MONTH(TODAY()), 1) && -- Excludes the current month YourTableName[Date] >= DATE(YEAR(TODAY()), MONTH(TODAY()) - 3, 1) -- Excludes the last 3 months )

Replace YourTableName with the name of your data table. This measure filters the data to include only rows where the date is earlier than the first day of the current month (excluding the current month) and no more than 3 months ago.

You can then use the "FilteredData" measure in your visualizations to display data up to the end of May 2023 if today's date is in June 2023.

[prvn8887]

 it's showing error as name DATE wasn't recognised. I'm working on power query and column name is PMTSUMMARY.......