To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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)
Hi @Atinder you could do this more easily in DAX.
IF(
PostedPO.[Posting_Date] >= today(),
TRUE(),
BLANK()
)
Hope this helps!