KPI with Max date

[ALLALOU]

Hello,

I Want to create a new KPI with the value of max date : 

example :

So my KPI I want diplay value : 109

Thanks

[dplr-rn]

try somehting like below expression in your kpi object

Sum( {<Date={"$(Max(Date))"}>} Sales)

[ALLALOU]

this solution return 0 

[dplr-rn]

try this too

Sum( {<Date={"$(=Max(Date))"}>} Sales)

[dplr-rn]

Sum( {<Date={"$(=Max(Date))"}>} Sales)

[ALLALOU]

the same, resull is 0 

[dplr-rn]

did a quick and dirty tryout in one of my apps. this is the expression i used.

=Sum({<OrderDate={"$(=Max(OrderDate))"}>}LineSalesAmount)

similar to one i shared before

share the exact expression you used

[ALLALOU]

I use this expression :

[dplr-rn]

substitute the Date with your own date fields i see from original post column names is different

[ALLALOU]

I use this expr now :

=Sum({<[Date.autoCalendar.Date]={"$(=Max(Date.autoCalendar.Date)))"}>}[Volume de commandes Année N])

but always the result is 0

[dplr-rn · Accepted solution]

there is an extra ) within the set analysis

=Sum({<[Date.autoCalendar.Date]={"$(=Max(Date.autoCalendar.Date))"}>}[Volume de commandes Année N])