CODEWITHSUNDEEP
powerbidax
Didier Ansermet
Didier Ansermet

Reputation: 1

SUM YTD sales but only until last month

Can somebody please help me: I am trying to SUM YTD sales but only until last month.

Today= 23.02.2023

The following formula sums up YTD sales until today (23.02.2023). However, I want to sum only until last month (31.01.2023).

Net Sales YTD = TOTALYTD( SUM('SAP'[Net sales]), year'Date'[Masterdate] )

.... here I want to exclude: PREVIOUSMONTH('Date'[Masterdate]))

Upvotes: 0

Views: 456

Answers (1)

Peter
Peter

Reputation: 12365

Try this measure:

YTD = 
VAR startDate = 
    DATE( YEAR(TODAY()) - 1, MONTH(TODAY()), DAY(TODAY()))
VAR endDate = 
    DATE( YEAR(TODAY()), MONTH(TODAY()), 1)
RETURN
    CALCULATE(
        SUM('Table'[Value]),
        startDate <= 'Table'[Date] && 'Table'[Date] < endDate
    )

Upvotes: 0

Related Questions