Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 😂 :
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
41 | |
23 | |
21 | |
21 | |
13 |