topic Re: Set Expression Involving Another Measure in App Development

Set Expression Involving Another Measure

cgT — Wed, 17 May 2023 14:39:33 GMT

Hello,

I'm currently trying to calculate a value based relatively on two measures:

PerformanceWeekCommencing

TransactionDate

I am unable to work out the expression that returns the sum(SoldValue) for the PerformanceWeekCommencing for transactions sold within that same week. I'm imagining something like this, which of course doesn't work:

Money(max(aggr(
sum({<TransactionDate= {'>=$WeekStart(PerformanceWeekCommencing)'}>}SoldValue),PerformanceWeekCommencing)))

Can anyone help, please?

Thank you in advance.

Re: Set Expression Involving Another Measure

Chanty4u — Wed, 17 May 2023 16:09:57 GMT

Try this

sum({$<TransactionDate = {">=$(=WeekStart(PerformanceWeekCommencing))<=$(=WeekEnd(PerformanceWeekCommencing))"}>} SoldValue)

Re: Set Expression Involving Another Measure

Kushal_Chawda — Wed, 17 May 2023 22:26:53 GMT

@cgT why you have used max over sum?

Re: Set Expression Involving Another Measure

cgT — Thu, 18 May 2023 08:01:50 GMT

So I can find the largest value derived from the sum calculation.

Re: Set Expression Involving Another Measure

cgT — Thu, 18 May 2023 08:07:38 GMT

Thanks for this, but it returns only a '0'.

Re: Set Expression Involving Another Measure

Kushal_Chawda — Thu, 18 May 2023 11:00:08 GMT

@cgT could you prepare sample data in excel to explain the scenario?