Forum Discussion

PPStar's avatar
PPStar
Helper V
3 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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