Forum Discussion

AndyAtDukes's avatar
AndyAtDukes
New Member
9 years ago
Solved

Struggling with DATEDIFF

Hi, this is my first post and my first report where I am trying dynamic date/time measures and visuals, not much success so far but almost certainly down to user error.   I am trying to find the di...
Need Help
  • AndyAtDukes's avatar
    AndyAtDukes
    9 years ago

    Matt,

     

    Actually I have found another solution to this, I created a column that works out the difference in days between TODAY() and the quotation date. I can then use this to filter any metric on any number of days.

     

    Thanks

     

    Andy

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
9 years ago

It is hard to follow your post. What are you actually  trying to do?

AndyAtDukes's avatar
AndyAtDukes
New Member
9 years ago

Matt,

 

Actually I have found another solution to this, I created a column that works out the difference in days between TODAY() and the quotation date. I can then use this to filter any metric on any number of days.

 

Thanks

 

Andy

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    9 years ago

    The problem with today() is it only works today. What if you want to see Howe many quotes they had "last 30 days" for each month this year on a chart to see a trend?  This won't work using the today approach. 

     

    Take a look at this article I wrote last week to help you get your head around the recommended approach 

    http://exceleratorbi.com.au/dax-time-intelligence-beginners/