Calculate year to date value based on the month selected in a slider

[Anonymous]

I have a date column CREATE_DATE and an ID column.  I would like to display in a card the count of the year-to-date of Ids based on a slider which is controlled by a column called MMM_YY.

For example if the User selects the slider to be 'January 2019" then the YTD is the number of rows in the ID column which could be 10.  However if the User selects March 2019 in the slider the values displayed in the card is 45 (say).

My dax expression does not work.  Could anybody help?  Thank you,

Count of CSR_NO_YTD_WITH_FILTER =

CALCULATE (

COUNT(WATER_QUALITY_APPREARANCE_DB[ID]),

FILTER(WATER_QUALITY_APPREARANCE_DB, WATER_QUALITY_APPREARANCE_DB[CREATE_DATE] <= MAX(WATER_QUALITY_APPREARANCE_DB[MMM_YY])

))

[amitchandak · Accepted solution]

You should try using SAMEPERIODLASTYEAR

Total Sales YTD Last Year = CALCULATE([Total Sales YTD],SAMEPERIODLASTYEAR('date'[date]))

In your case. First, find the date and use that in the above formula

Var1 date1 =calculate (max(WATER_QUALITY_APPREARANCE_DB[created_date]),(WATER_QUALITY_APPREARANCE_DB[MMM_YY]))

Refer

https://community.powerbi.com/t5/Desktop/How-to-display-sales-YTD-and-sales-last-YTD-over-years/td-p...

https://databear.com/power-bi-tips-calculating-year-to-date-values/

Preferably have a date calendar and marked that to the date calendar in the Model view