Forum Discussion
Solved
Filter table to show data for current month
Hi, i have a table (Called Records) which looks like below Number | Created On 12432 | 12/4/2021 332535 | 15/05/2022 334525 | 01/01/2023 435315 | 14/01/2023 335325 | 2/5/2021 T...
Hi PPStar ,
Here are the steps you can follow：
1. Create calculated table.
records = var _table= SUMMARIZE( 'Table','Table'[Create On],'Table'[Number],"Year",YEAR('Table'[Create On]),"Month",MONTH('Table'[Create On])) return FILTER( _table,[Year]=YEAR(TODAY())&&[Month]=MONTH(TODAY()))2. Result:
Does it meet your expected results
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi PPStar ,
I created some data:
Date:
Here are the steps you can follow：
Create calculated table.
Monthly data:
Every Month =
var _table=SUMMARIZE('Date','Date'[Year],'Date'[Month])
return
ADDCOLUMNS(
_table,"Value",
SUMX(FILTER(ALL('Table'),
YEAR('Table'[Create On]) =[Year] && MONTH('Table'[Create On]) =[Month]),[Number]))
Current month's data:
Current Month =
var _table=
SUMMARIZE('Date','Date'[Year],'Date'[Month])
var _table2=
FILTER(
_table,
[Year] = YEAR(TODAY()) && [Month] =MONTH(TODAY()))
return
ADDCOLUMNS(
_table2,"Value",
SUMX(FILTER(ALL('Table'),
YEAR('Table'[Create On]) =[Year] && MONTH('Table'[Create On]) =[Month]),[Number]))
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks for this. But would this return me the records for that month?. I need to see all the records for that particular month, not the value of records?
