Forum Discussion
sdhn
Responsive Resident
Responsive ResidentSubtract two date columns in existing table
Hi All, I am using Power Bi Desktop to develop report. I need to add new column that computes elapsed time (Resolved date – Created date = Elapsed) Both columns are date. Do I need to wr...
Elapsed =
VAR _diff = [Resolved Date Time] - [Created]
RETURN IF([Resolved Date Time]=BLANK(),0,_diff)
sdhnResponsive Resident
Responsive ResidentElapsed =
VAR _diff = [Resolved Date Time] - [Created]
RETURN IF([Resolved Date Time]=BLANK(),0,_diff)