Datediff

Anything related to PowerPivot and DAX Formuale
pdelg
Posts: 1
Joined: Sun Aug 25, 2019 7:38 pm

Datediff

Postby pdelg » Sun Aug 25, 2019 7:46 pm

Hi Everyone,

I can't seem to get my date diff working, all the videos I have watched show it working with what I have written, could you please help. I have attached what I am doing. I just want a column with the difference between the org sent and org received column in days?

Many thanks

Paul
Attachments
Capture.PNG
Capture.PNG (123.67 KiB) Viewed 162 times

Wrencher
Posts: 10
Joined: Thu Jan 19, 2017 2:37 pm

Re: Datediff

Postby Wrencher » Tue Aug 27, 2019 1:51 pm

The formula looks right. I tried this in my Excel workbook and didn't get an error. Try creating a new table in excel with a header and just a few lines with start date and end date, add to data model, then try the formula. Double check the columns have the data type set to date.

datedifftest.JPG
datedifftest.JPG (27.88 KiB) Viewed 140 times


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 0 guests