Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Sum until endofmonth selected date

How to sum dates until end of selected date month?

nor this

 

 

        CALCULATE (
            SUM ( 'Table'[SUM] ),
            FILTER (
                'Table',
                'Table'[State] IN { "on", "off" } &&
                'Table'[DATE] <> BLANK() && 
                'Table'[DATE] <= EOMONTH('Table'[DATE],0)
            )
            
        )

 

 

nor this

 

        CALCULATE (
            SUM ( 'Table'[SUM] ),
            FILTER (
                'Table',
                'Table'[State] IN { "on", "off" } &&
                'Table'[DATE] <> BLANK() && 
                'Table'[DATE] <= ENDOFMONTH('Date'[date])
            )
        )

 

 Is not work , as not sum until selected with date slicer date endof month

1 Reply