Forum Discussion

campbep's avatar
campbep
Regular Visitor
9 years ago

Date qualification on a dynamic date value

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!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     

    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.