How to display the records of ytd, qtd, mtd etc., based on parameter date selection

[Raj341]

Hi Everyone,
I have data with dates, category and values. now i need to show the values based on parameter selection.

To get the results of currentday(Today), I am getting the correct results based on the parameter selection.
Formula, which i used to get the results.
-----------------------------------------------------------------
Today =
var _date = SELECTEDVALUE(date[Dates])
var _today = CALCULATE(SUM(Table[Value]),FILTER(Table,Table[Dates] = _date))
RETURN
_today
----------------------------------------------------------------------

--date --> parameter
--Dates --> column
If i execute the similar formula for yesterday, results showing blanks and for one "category" showing previous date as different date.

I need to show the similar results for Today, Yesterday, Same period last year, week to date, month to date, Quarter to date
same period last year to date, Year to date.

Today

Yesterday

Same period last year

Week to date

Month to date

Quarter to date

sply QTD

YTD

sply YTD

Results should be like this, Category is like a,b,c etc.,

Please help me . I am unable to fix the issue
@v-yueyunzh-msft  @RasCZ 
it will be a great help for me

[Raj341]

@_AAndrade 
I am unable to upload powerbi file. data is like almost similar to the image

[_AAndrade]

Hi @Raj341,

Could you please share your pbix with same data so I take a look?