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 September 15. Request your voucher.

Reply
Atinder
Helper III
Helper III

Add IF date formula in the custom date

Hello, 

I want to add a custom date column in the table by using IF function. 

 

I want to see what items I received today by the posting date. 

 

= Table.AddColumn(#"Expanded PostedPO", "Custom", each if [PostedPO.Posting_Date] >= #date(today()) then "yes" else null)

1 REPLY 1
littlemojopuppy
Community Champion
Community Champion

Hi @Atinder you could do this more easily in DAX.  

IF(
	PostedPO.[Posting_Date] >= today(),
	TRUE(),
	BLANK()
)

Hope this helps!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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