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))
  • schoden's avatar
    schoden
    Post Partisan
    5 years ago

    Hi Ashish_Mathur  Thanks for the share .  I am facing problem to show zero value for all blank months in the specified date range.