Forum Discussion

AlunThomas's avatar
AlunThomas
Frequent Visitor
2 years ago

DATESBETWEEN function ignoring LASTDATE Measure

Hi Everyone;   Firstly - thank you to the community for your help. My last question was answered switfly and professionally. I am new to Power BI so appologies in advance if i ask a stupid question...
AlunThomas's avatar
AlunThomas
Frequent Visitor
2 years ago
MonthProductTotalWeight[kg]

01/06/2023

Product A

120
05/02/2022Product A100
06/02/2023Product A50
01/01/2023Product A60
03/04/2022Product A100
03/04/2022Product B120

 

I then want a slider to select a date range from, say, 03/04/2022 to 06/02/2023 and this would then return weights by product for the given date range only. So the resulting "answer" would look like this:

ProductTotalWeight[kg]
Product A210
Product B120

 

My intention was to use the measures MaxDateFG (ie 06/02/2023) and MinDateFG (ie 03/04/2022) to establish the filter dates from the slider.  But my measures seem to be ignoring the slider filters. Hope i am making sense. 

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

    hi, AlunThomas 

    your code is right but when you select date range from slicer then slicer include all date bw your first and last date .

    means 

     

    from your above data if you select date range bw (03/04/2022 to 06/02/2023)  slicer include all date from 
    (03/04/2022 to 06/02/2023 ) which is 91 dates not 4 date .

     

    so when you move range  your range not exced actual date(present in table ) so data not change and you feel that above code is not working

     

    i hope you clear about that