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 would like to filter a column that only contains data until the last day of the last month.
Also I can say all data before current month.
It will give acumulative figures for Balance at date of end of month .
Solved! Go to Solution.
Hi @aldanab ,
Have you solved your problem? If not, please try this way.
Here is my sample data:
You can use this M function to achieve filter:
= Table.SelectRows(#"Changed Type", each [Date] < Date.StartOfMonth(DateTime.Date(DateTime.LocalNow())))
The output is as below:
And about "It will give acumulative figures for Balance at date of end of month", my understanding is that you want to sum the values for each month. You can follow these steps:
Add two Custom Columns to find the month and year of Date:
And the table is as below:
Then use Group By function:
And the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @aldanab ,
Have you solved your problem? If not, please try this way.
Here is my sample data:
You can use this M function to achieve filter:
= Table.SelectRows(#"Changed Type", each [Date] < Date.StartOfMonth(DateTime.Date(DateTime.LocalNow())))
The output is as below:
And about "It will give acumulative figures for Balance at date of end of month", my understanding is that you want to sum the values for each month. You can follow these steps:
Add two Custom Columns to find the month and year of Date:
And the table is as below:
Then use Group By function:
And the final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you !! I made it work with this filter
Roughly like this:
<date> <=EOMONTH(TODAY(),-1)
I couldnt make it work with this. But I finally found it simply, It will work for some years , but not for ever 😂 :
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.