Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone please help with this requirement in set analysis.
Condition - [LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}
I want to have this condition in set analysis and show the max of LP past due days using group by based on customer name
I wrote my expression as
({<[LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}>}[LP Days Past Due])
But I'm unable to put max and group by in same expression.
Thanks.
Sachin
The max days would be
=max( ({<[LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}>}[LP Days Past Due])
and the Amt
=FirstSortedValue({<[LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}>} [LP Delinquent Amt], -[LP Days Past Due])
in a chart with dimension Customer.