Forum Discussion
Struggling with DATEDIFF
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
Community ChampionIt is hard to follow your post. What are you actually trying to do?
Hi Matt, thanks for your reply.
I have a data set of quotations created by our sales team, I am trying to build a quote performance report which will show;
Last 30, 90 & 180 days rolling number of quotes, value of quotes, conversion ratio etc with year/year comparison.
In addition I have a calendar table with sequential dates, months, years etc
I was trying to create the IsMonth column in order to then be able to filter by this to get that 30 days rolling data.
Hope that makes some sense,
Andy
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
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/