Forum Discussion

ArdraM's avatar
ArdraM
Frequent Visitor
2 years ago
Solved

Dynamic date range selection

Hi,   I've a date slicer in my report that is of type before. Here is the requirement I'm struggling with:   If the date selected is 5/1/24 (1rst of may) then date range taken for all calculation...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    use the below measure

    End Date = MAX('Calendar'[Date])
    Start Date =
    var a = 'Calendar'[End Date]
    var b = IF(DAY('Calendar'[End Date])=1,-2,-1)
    var c = EOMONTH('Calendar'[End Date],b)+1
    return c
    I am getting the expected output

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

use the below measure

End Date = MAX('Calendar'[Date])
Start Date =
var a = 'Calendar'[End Date]
var b = IF(DAY('Calendar'[End Date])=1,-2,-1)
var c = EOMONTH('Calendar'[End Date],b)+1
return c
I am getting the expected output