Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.