Want to show Current Year YTD till Previous month

[AshDil]

Hi,

I have tried to calculate YTD till previous month using following formula,
YTD sales = Calculate(TOTALYTD('TABLE'[SALES],'CALENDAR'[DATE'), FILTER('CALENDAR','CALENDAR'[YEAR] = YEAR(TODAY()) && 'CALENDAR'[MONTH_NO] = MONTH(TODAY())-1))))

But I'm not getting correct results.

Please help me to do it.

Thanks,

AshDil.

[amitchandak · Accepted solution]

@AshDil , Try a measure like

YTD Today till last month =
var _min = Date(year(Today()),1,1)
var _day = eomonth(today(),-1)
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date] >=_min && 'Date'[Date] <= _day) )

Remove all date date it date is not selected

YTD Today till last month =
var _min = Date(year(Today()),1,1)
var _day = eomonth(today(),-1)
return
CALCULATE(sum('Table'[Qty]), FILTER(('Date'),'Date'[Date] >=_min && 'Date'[Date] <= _day) )

[Jihwan_Kim · Accepted solution]

Hi, 

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

Sales total: =

SUM( Data[Sales] )

Sales YTD: =

CALCULATE( [Sales total:], DATESYTD('Calendar'[Date] ))

Sales YTD until previous month: =

IF ( HASONEVALUE ( 'Calendar'[Month & Year] ), [Sales YTD:] - [Sales total:] )

[amitchandak · Accepted solution]

@AshDil , Try a measure like

YTD Today till last month =
var _min = Date(year(Today()),1,1)
var _day = eomonth(today(),-1)
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date] >=_min && 'Date'[Date] <= _day) )

Remove all date date it date is not selected

YTD Today till last month =
var _min = Date(year(Today()),1,1)
var _day = eomonth(today(),-1)
return
CALCULATE(sum('Table'[Qty]), FILTER(('Date'),'Date'[Date] >=_min && 'Date'[Date] <= _day) )