topic Re: Date duration with if stament in DAX Commands and Tips

Date duration with if stament

wmedin2022 — Fri, 30 Dec 2022 03:57:54 GMT

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!

Re: Date duration with if stament

Anonymous — Fri, 30 Dec 2022 04:38:49 GMT

Hi wmedin2022

Can you share the sample data?

Re: Date duration with if stament

TomasAndersson — Fri, 30 Dec 2022 06:47:33 GMT

Hi!

Duration.Days expects one argument, a difference between two dates, so you need to use a minus sign instead of a comma there. You also need to convert DateTime.LocalNow() from DateTime to Date. Try something like:

= Table.AddColumn(#"Extracted Month Name", "Days_Passed", each if[Status] = "Complete" then Duration.Days([Date Closed]-[Date]) else Duration.Days(DateTime.Date(DateTime.LocalNow())-[Date]))

Hope this helps!

Re: Date duration with if stament

wmedin2022 — Fri, 30 Dec 2022 15:08:05 GMT

It works!!!

Thank you