Select days from relative date slicer

[dennisdepoorter]

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

[v-lili6-msft · Accepted solution]

hi, @dennisdepoorter

 You may try to use this formula as below:

Measure = DATEDIFF(MIN('Order'[ActivatedDate]),TODAY(),DAY )+1

Result:

Best Regards,

Lin

[dennisdepoorter]

THANKS @v-lili6-msft this works indeed!!!! 🙂

[Greg_Deckler]

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