Dax Calculated Column

[Kumarun]

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.

[Icey · Accepted solution]

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.

[Kumarun]

=SWITCH (
TRUE (),
[date]
>= EOMONTH ( TODAY (), -3 ) + 1
&& [date] <= EOMONTH ( TODAY (), 0 ), FORMAT([date],"dd-mm-yyyy")
)

Display the date, so i'm using format function

[amitchandak]

@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)