Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Adding days since from a SQLdb Report

Good Morning PowerBI!   I have a report that queries a sql db directly and noticed if I added tables, it changes the type of report which will download all the tables which takes a while.   I was...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

Has your problem been solved?

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-lionel-msft Hi Lionel,

     

    I actually figured it out. On a direct query database, if you use a measurement it will achieve what you need and in my case, it was days from a certain field.

     

    Difference = DATEDIFF( *Table*[*Field*], TODAY(), DAY)
     
    adding this measurement allowed me to calculate the days passed from *field* (this was a date entered) without changing it from direct query.
    I added this for a group of folks who wanted to see immediate changes (refresh button mashers).
     
    Hopefully this may help other folks dealing with refresh mashers as well.