Forum Discussion

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Sowmiya

Follow Sowmiya's suggestion, you could use YTD, MTD, QTD,WTD,DTD, Half -Year in the measure to calculate the values.

Addition to that, according to your previous post, what you want is partly achieved in Power BI currently.

 

Per your requirement, the relative date slicer gets us close to this with the “last”, “this”,  “next”, of “Day”, “Week”, “Month” or “Year” settings. That is a dynamic date selection that updates based on the current system date.

Please find more details here.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

 

Currently it doesn't support "Quarter" and "Half year", please vote for this idea to improve this feature

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19321789-dynamic-date-slicer-improve-relative-date-slicer

 

To workaround this, you could create timeperiod slicer, for example

http://analyticsavenue.com/power-bi-timeperiod-slicer-for-last-7-dayslast-30-days/

 

Best Regards

Maggie