Hi All,
I have 2 different dates in my data set(Manufacture and Sale). Now the requirement is to create a KPI which always shows max year and month count.
for which i can write 2 expressions for each date, which works perfectly. ex:
='Manufacure Count: '&Count({<Mani_Month_Nm={"$(=max(Mani_Month_Nm))"}, Mani_Year={"$(=max(Mani_Year))"}, Mani_Month>}Item)
='Sales Count: '&Count({<Sal_Month_Nm={"$(=max(Sal_Month_Nm))"}, Sal_Year={"$(=max(Sal_Year))"}, Sal_Month>}Item)
But, i want to avoid writing 2 expressions and make dynamic a single one.
=Count({<$(vMoM)={"$(=max($(vMoM)))"}, $(vYoY)={"$(=max($(vYoY)))"}, $(vM)=>}Item)
Here the problem is applying max function to the variable(it is not working).
Appreciate any help(attached sample app).
