if staments
1 Topic
Date duration with if stament
Hi All, im stuck with the follwing DAX command on my power query. I want to Days Passed to calculate the duration in days based on the status. If status is "complete" then calculate duration from date to date complete. if <> complete then calculate date to current date or Today.I I get this error message Expression.Error: 2 arguments were passed to a function which expects 1. Details: Pattern= Arguments=[List] this is my DAX = Table.AddColumn(#"Extracted Month Name", "Days_Passed", each if [Status] = "Complete" then Duration.Days([Date], [Date Closed]) else Duration.Days([Date], DateTime.LocalNow())) Thanks in advance!Solved975Views0likes3Comments