Forum Discussion
Solved
Calculated Column based on Dates
I'm trying to find out the Aging of a case wcich registered in our system. In my dataset I have 2 date feilds. Assigned Date, and Completed Date. I have created a calculated column by subtracting...
EbyEaso OK, so:
= if 'SQL-DATE-UPDATED'[CompletedDate] = null then DateTime.LocalNow() - 'SQL-DATA-UPDATED'[AssignedToDate] else 'SQL-DATE-UPDATED'[CompletedDate] - 'SQL-DATA-UPDATED'[AssignedToDate]
Sorry Greg_Deckler
I'm beginner. 🙂 Trying to get solve these.
in DAX also i got error.
And in Power Query I got this.
Greg_Deckler
Finaly I got it. My Assigned To Date was in date time format. I think that was the issue. I changed that Date only format and added additional column to show todays date. Instead of using this
DateTime.LocalNow()
Now its fine.
Thank You Greg_Deckler for the valuable support. Appreciate it.