Creating a Date Parameter with Specific Time Frames in Power BI

[manoj_0911]

I'm seeking guidance on creating a date parameter within Power BI that provides the following values for time frames: today, yesterday, this week, last week, this month, last month, this quarter, last quarter, this year, last year, and the option for a custom range with a start and end date.

Could someone kindly provide insights or guidance on how to achieve this within Power BI?

Attached is a sample dataset.

[v-shex-msft]

HI @manoj_0911,

I'd like to suggest you add a custom column to check the current time value field and return different tags. Then you can use these tags as source of slicer to filter records.

Regards,

Xiaoxin Sheng

[manoj_0911]

i'm new to power bi could you please help on this, my table name is agent_subhour_v and it has a date column called ixn_subhour_date