Forum Discussion

schoden's avatar
schoden
Post Partisan
5 years ago
Solved

Apply Certain Date Range using ISBLANK

Hi Community,    I have a measure to calculate total sales:       M= SUM(Sales[sales])       Now  I have put Date Range to show next 6 Months including current Month Feb 2021.     N= ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    schoden , Try like

     

    0 between range 
Measure = var _1= CALCULATE(SUM(Sales[sales]), DATESINPERIOD( Date, NOW(), 6 , MONTH)) +0 
var _min = calculate(minx('Calendar', 'Calendar'[Date]) ,DATESINPERIOD( 'Calendar'[, NOW(), 6 , MONTH))
var _max = calculate(maxx('Calendar', 'Calendar'[Date]) ,DATESINPERIOD( 'Calendar'[, NOW(), 6 , MONTH))
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
amitchandak's avatar
amitchandak
Super User
5 years ago

schoden , Create a measure like below example

 

0 between range
Measure = var _1= SUM(sales[sales]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))

 

  • schoden's avatar
    schoden
    Post Partisan
    5 years ago

    hi amitchandak  the measure still doesnt show zero for the blank months.

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      schoden , here min-max, need to be from six-month range.

      • schoden's avatar
        schoden
        Post Partisan
        5 years ago

        Yes amitchandak  I have put flag check for next 6 months.  still doesnt show zero