Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |