Forum Discussion

bryn987's avatar
bryn987
Helper I
3 years ago
Solved

Date filter - Relative Dates

Is in the last Calendar Months So, I like this filter as it shows me data from previous full months.  However, it does not show me the current months of data so you can't compare to see how your cur...
  • amitchandak's avatar
    3 years ago

    bryn987 , refer if this approch can help

     

    https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79

     

    And few measures

     

    This Month =
    var _max = eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),0)
    var _min = eomonth(_max,-1)+1 ,
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

     

     

    Last Month =
    var _max1 = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
    var _max = eomonth(_max1,-1)
    var _min = eomonth(_max1,-2)+1
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

     

     

    Rolling 2 =
    var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
    var _min = Date(Year(_max), month(_max) -2, Day(_max))+1,
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

     

     

    rolling 3 =
    var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
    var _min = date(Year(_max), month(_max) -3, Day(_max))+1
    BLANK())
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))

     

    or

     

    rolling 3 =
    var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
    var _min = eomonth(_max,-3)+1
    BLANK())
    return
    CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))