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,

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

    Here you can see details. Results are not correct for some reason. Results are like x2 / x3

     

    When filtering

    Client to = A

    Policy Year = 2020

    Month from 202002 to 202006

    Result have to be 151

    But it gives result: 273

     

    DAX measure I am currently using is:

    Period1 =
    sumx(filter(allselected('(Table 1) Month'),
    '(Table 1) Month'[Client] = [Client] &&
    '(Table 1) Month'[Policy Year] = [Policy Year] &&
    '(Table 1) Month'[Month] >=SELECTEDVALUE('Start Date'[Month From]) &&
    '(Table 1) Month'[Month] <=SELECTEDVALUE('End Date'[Month To])),
    '(Table 1) Month'[Days of Month])