Forum Discussion
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.
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.
3 Replies
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)
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.
=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
