Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

date diff-row count if condition apply

Dear Friends   i have two dates column date1 and date2,   and calculatting the difference by measure by comparing constant value Z=3:   Measure = var z=3 VAR diff=SUMX(Sheet1,DATEDIFF...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Rename your current measure to be Measure Individual and then create a new measure

    Measure = IF( ISINSCOPE( 'Table'[date1]), [Measure Individual],
SUMX( ADDCOLUMNS( SUMMARIZE( 'Table', 'Table'[date1], 'Table'[date2]),
   "@val", [Measure Individual] ),
[@val] )
)
johnt75's avatar
johnt75
Super User
4 years ago

Rename your current measure to be Measure Individual and then create a new measure

Measure = IF( ISINSCOPE( 'Table'[date1]), [Measure Individual],
SUMX( ADDCOLUMNS( SUMMARIZE( 'Table', 'Table'[date1], 'Table'[date2]),
   "@val", [Measure Individual] ),
[@val] )
)