Forum Discussion

Akbarov's avatar
Akbarov
Icon for Helper I rankHelper I
4 years ago
Solved

SUMIF >= column1 AND <= column2

Hello,   I am trying to use following SUMIF formula for DAX measure:   =SUMIFS('(Table 1) Month'!G:G, '(Table 1) Month'!A:A,Output!K17, '(Table 1) Month'!B:B,Output!L17, '(Table 1) Month'!C:C,...
  • DimaMD's avatar
    DimaMD
    4 years ago

    Akbarov Make two-way communication and your measure Period 2 will work,

DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
4 years ago

Akbarov Make two-way communication and your measure Period 2 will work,

  • Akbarov's avatar
    Akbarov
    Icon for Helper I rankHelper I
    4 years ago

    Thank you soooo much!

    • DimaMD's avatar
      DimaMD
      Icon for Solution Sage rankSolution Sage
      4 years ago

      Akbarov after having fun with Period1, the event is the following

      Period1 = 
var _sel1 = SELECTEDVALUE('Start Date'[Month From])
var _sel2 = SELECTEDVALUE('End Date'[Month To])
var res =
sumx( filter( '(Table 1) Month', 
AND('(Table 1) Month'[Client] = [Client], '(Table 1) Month'[Policy Year] = [Policy Year]) && 
AND( '(Table 1) Month'[Month] >= _sel1 , '(Table 1) Month'[Month] <= _sel2)),
'(Table 1) Month'[Days of Month])
return
res