topic Re: Dax Calculated Column in DAX Commands and Tips

Dax Calculated Column

Kumarun — Tue, 31 May 2022 08:41:31 GMT

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.

amitchandak — Wed, 01 Jun 2022 02:42:20 GMT

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)

Icey — Fri, 03 Jun 2022 03:08:24 GMT

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 — Fri, 03 Jun 2022 04:51:07 GMT

=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