Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Help on Sum

Hi,   Need help in attached file. I've the calcualted Columns attached in my dataset.  I've Columns    Month, Result and Diff.   Requirements are    1. The required column should be sum of al...
Tips and Tricks
  • dax's avatar
    dax
    7 years ago

    Hi

    You could create a table for Month slicer, then use below measure

    measurem =
IF (
    MONTH ( MIN ( Table6[date] ) ) > SELECTEDVALUE ( 'Month'[month] ),
    SUM ( Table6[amount] ),
    SUM ( Table6[diff] )
)

    Best Regards,

    Zoe Zhi

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

Please try below measure:

Measure 2 = IF(MAX('Table (2)'[Month]) < DATE(2019,8,1),SUM('Table (2)'[Diff]),SUM('Table (2)'[Result]))

Aiolos Zhao