Forum Discussion

mesuyog's avatar
mesuyog
Regular Visitor
4 years ago
Solved

Custom date filter

I have to create custom date filter where Month start should be last months 13 and month end should be that months 12. For Example - Normally : January 2022 Starts - 1st ends at 31st I need : ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi mesuyog ,

     

    What's your expected output? If you want to simply apply a date filter, you may drag Date column to Slicer field, then you could custom date period:

    Or if you want to re-arrange the date month, for example, 

     2021 December is  from   2021/12/13  to   2022/1/12  

     2022 January     is  from   2022/1/13    to   2022/2/12 

     

    Please create a column:

    New YearMonth = 
var _date=IF(DAY([Date])>=13,[Date],EOMONTH('Table'[Date],-1))
return FORMAT(_date,"yyyy mmmm")

    And I created another column for sort:

    Output:

     

    Best Regards,
    Eyelyn Qin
    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
4 years ago

Hi mesuyog ,

 

What's your expected output? If you want to simply apply a date filter, you may drag Date column to Slicer field, then you could custom date period:

Or if you want to re-arrange the date month, for example, 

 2021 December is  from   2021/12/13  to   2022/1/12  

 2022 January     is  from   2022/1/13    to   2022/2/12 

 

Please create a column:

New YearMonth = 
var _date=IF(DAY([Date])>=13,[Date],EOMONTH('Table'[Date],-1))
return FORMAT(_date,"yyyy mmmm")

And I created another column for sort:

Output:

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.