Forum Discussion

Atinder's avatar
Atinder
Icon for Helper III rankHelper III
4 years ago

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)

Data Protection
Need Help
Show and Tell
Tips and Tricks

1 Reply

  • littlemojopuppy's avatar
    littlemojopuppy
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Atinder you could do this more easily in DAX.  

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

    Hope this helps!