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


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

Capture.PNG (123.67 KiB) Viewed 256 times

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 (27.88 KiB) Viewed 234 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests