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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
levcovitz
Frequent Visitor

Advanced Relative Date Filtering - 6 months after specific date

Hello!

 

I have to create a visual that shows data from 6 months after an specific date. The goal is to analyze KPIs from campaingns in the first 6 months after they were released. It will show only one campaingn at a time.

 

My dCalendar starts at 1990, but some campaings were released e.g. in May/2020. Therefore, I need the visual to show the results from May to Oct/2020. If I filter another campaingn (e.g. Jan/2019), I will need the visual to show the results from Jan to Jun/2019, etc.

 

Is there any way I can do that in Power BI? 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@levcovitz , if you select a date and want to data more than that. Then slicer need to be independent date table

 

//Date1 is independent Date table, Date is joined with Table
new measure =
var _min= maxx(allselected(Date1),Date1[Date])
var _max= eomonth(_max, 5)
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@levcovitz , if you select a date and want to data more than that. Then slicer need to be independent date table

 

//Date1 is independent Date table, Date is joined with Table
new measure =
var _min= maxx(allselected(Date1),Date1[Date])
var _max= eomonth(_max, 5)
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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