Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
campbep
Regular Visitor

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 1
Anonymous
Not applicable

 

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.