topic Re: How to restrict a measure? in App Development

How to restrict a measure?

Sun, 16 Apr 2017 09:56:16 GMT

Sorry if it sounds silly but i want to use a KPI to display sales for current quarter independently of what selection user make.

I tried Sum({<[Date.autoCalendar.YearQuarter]={'2017-Q1'}>}Sales) and it works.

How can I make the year-quarter value dynamic instead of fix value? I want the KPI to display current year-quarter data.

Re: How to restrict a measure?

Anonymous — Mon, 17 Apr 2017 08:52:51 GMT

Use a filter for YearQuarter and try use like Sum({<[Date.autoCalendar.YearQuarter]={"$(Max(YearQuarter))"}>}Sales) in the expression. Or you can even use a variable by assigning a value to it from input box.

Re: How to restrict a measure?

rahulpawarb — Mon, 17 Apr 2017 11:29:50 GMT

Hello Sara,

You can try below given expression. This will show you Sales Total irrespective of current selection.

Sum({<[Date.autoCalendar.YearQuarter]={"$(=Year(Today()) & '-Q' & If(Ceil(Month(Today())/3) >=2, Ceil(Month(Today())/3)-1, Ceil(Month(Today())/3) + 3))"}>}Sales)

Hope this will be helpful.

Regards!

Rahul

Re: How to restrict a measure?

satheshreddy — Tue, 18 Apr 2017 08:50:00 GMT

Hi Sara,

use dynamic variables in place of values.

Regards

Sathish

Re: How to restrict a measure?

david_pearson — Thu, 09 May 2019 15:53:12 GMT

Try this

Sum({$< Date.autoCalendar.YearQuarter ={">=$(=QuarterStart(Today(),0))<=$(=Today())"}>}Sales)

otherwise try

Sum({$< Date ={">=$(=QuarterStart(Today(),0))<=$(=Today())"}>}Sales)