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...
Data Protection
Need Help
Show and Tell
Tips and Tricks
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!