Forum Discussion
Helper ISelect days from relative date slicer
Hi All,
I like to select the days out of the relative date slicer.
De reason is that we always make predictions based on L30D. But of we want to make the predictions on L120D, we need to recalculate it to 30D (L120D / 120 * 30). The only way I can do this, is getting the number of days out of the relative date slicer.
I tried this with Selectedvalue,... but doesn't work :(
Tanks,
Dennis
hi, dennisdepoorter
You may try to use this formula as below:
Measure = DATEDIFF(MIN('Order'[ActivatedDate]),TODAY(),DAY )+1Result:
Best Regards,
Lin
4 Replies
v-lili6-msftCommunity Support
hi, dennisdepoorter
You may try to use this formula as below:
Measure = DATEDIFF(MIN('Order'[ActivatedDate]),TODAY(),DAY )+1Result:
Best Regards,
Lin
dennisdepoorterTHANKS v-lili6-msft this works indeed!!!! :)
- Greg_Deckler
Community Champion
Can you provide sample data and the DAX calculations you are using? You should just be able to use COUNTROWS(CalendarTable) in your formula. That would tell you how many days you are dealing with 30, 60, 120. But I'd need additional information to be sure.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- dennisdepoorter
Hi Greg_Deckler,
Thanks for your quick response!
You can find a test environment with fictief data and no Salesforce link here: https://www.dropbox.com/s/vupkg4chx07v5hf/test.pbix?dl=0
Best,
Dennis
