Date qualification on a dynamic date value

[campbep]

Hello,

I am looking for a feature in PowerBI which exists in other BI tools such as MicroStrategy. I am hoping there is a similar functinality in PowerBI.

I have a DateTime column which I need to use as a filter, in the filter qualifications section I need the date to be evaluated to current month - 1. The equeation psudo code would be something like : [DATETIME] is greater than or equal to NOW() - 1 This is a very simple feature in other tools and I am failing to find it in PowerBI. Does this feature exist?

Thanks!

[Anonymous]

I use to create columns like:

[TodayColumn] = Today()

[FlagPrevMonth] = IF( [datetime] >= dateadd([TodayColumn];-1;Month) ; "Y"; "N" )

This is not the best way, but works.