Forum Discussion

Kumarun's avatar
Kumarun
Helper I
4 years ago
Solved

Dax Calculated Column

Need to display the previous month's dates and this month's dates by using the existing dates column.   Not basic filtering and advanced filtering.
a
  • Icey's avatar
    Icey
    4 years ago

    Hi Kumarun ,

     

    Please check if the method amitchandak provided could meet your requirements.

     

    And just a little correction:

     

    Flag =
    SWITCH (
    TRUE (),
    [Date]
    >= EOMONTH ( TODAY (), -2 ) + 1
    && [Date] <= EOMONTH ( TODAY (), 0 ), 1,
    0
    )

     

     

    Best Regards,

    Icey

     

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

amitchandak's avatar
amitchandak
Super User
4 years ago

Kumarun , if you need a column, then you need create a flag

 

Flag =

Switch( True() ,

[Date] >=  eomonth(today(),-2) +1  && [Date] <= eomonth(today,0) , 1 , 0)