Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
tamerj1
Super User

Hi Midway 

Please try

=
CALCULATE (
    SUM ( Sales[SalesAmount] ),
    DATESMTD ( DimDate[Date] ),
    Sales[SaleStatus] = "Active"
)

View solution in original post