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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Annemie19
Helper II
Helper II

power bi dates measure

Hi there, 

 

I want to create a measure that will show only the dates that are before today and future days that are before 90 days from now. 

 

Thanks, 

Annemie

2 REPLIES 2
amitchandak
Super User
Super User

@Annemie19 , Try like

//date related to table

measure = calculate(sum(Table[value]),filter(all(Date), Date[Date]<=Today() || Date[Date]>=Today()+90))

or

measure = calculate(sum(Table[value]),filter(Date, Date[Date]<=Today() || Date[Date]>=Today()+90)) //date not filtered

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

thanks a lot for the help, 

 

Should (sum(table[value])) be the table name or date field name? 

 

I want the date to be displayed. 

 

I am getting the following error

 

Annemie19_0-1601311676956.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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