Calculating the number of days between a date and todays date

[Anonymous]

I have no idea how microsoft manage to make such a simple thing so complicated? 

I have an excel file connected to PowerBI and a text columnn has been "transformed" to date value, all looks OK etc. The colum is called [StatDueOn].

Now the magic? Just trying to calculate Now()-[StatDueOn] OR whatever the formula is.....takes 2 secs to do this in Excel/Access, but keep getting errors.  What is the correct syntax. I have added a custome column when I do this.....called DaysLate

[az38]

hi @Anonymous 

try new calculated column 

Column = DATEDIFF([StatDueOn], NOW(), day)

[Anonymous]

HI is this in the query edit phase, or on the BI/Graphics phase? Have realised (reswitched brain on!) that new measures can be added post transformation, whereas I was trying to do all calcs during the backend phase.....

---

@az38 wrote:

hi @Anonymous 

try new calculated column 

Column = DATEDIFF([StatDueOn], NOW(), day)

---

[az38 · Accepted solution]

Hi @Anonymous 

It is in the Modeling pane in "BI/Graphic phase"

[Anonymous]

Worked ok then - before it was not finding [StatDueOn] - note I added NEW Column and not new measure etc and it was fine.

---

@az38 wrote:

Hi @Anonymous 

It is in the Modeling pane in "BI/Graphic phase"

---