Forum Discussion

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.

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.

Community Support

4 years ago

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.

Helper I

4 years ago

=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