How to get data for WTD ,MTD and QTD in Power Bi

[Sathvik123]

Hello All,

I have a report where I need to filter my data based on trendtype.

The columns I have are Date,TrendType and Sales as below

So I created a slicer called trendtype having 4 values  daily, weekly,Monthly and Quarterly

So data is already aggrigated for daily , weekly and monthly (dont have data for Quartely)

If user selects daily in slicer then I need to show last 30 days data

Weekly then last 12 weeks data and also I need to show WTD data too

Monthly then last 12 Months data and also I need to show MTD data too

Quarterly then last 4 Quarters data and also I need to show QTD data too

Could any one please help , how to do this

[mh2587]

https://community.powerbi.com/t5/Desktop/Change-time-period-week-Month-Quarter-on-slicer-selection/t...

Hope this will help you