Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
sum({<Is = {'N'},IsH = {'N'},[Date]= {">=$(vFrom)<=$(vTo)"},
[order Date]= {">=$(vGFrom)<=$(vGTo)"}> }[Cost])
I used Aggregate as below but getting error. i want to use aggr function because the total when exported in excel was not correct . Am i missing something from bellow expression
sum(aggr({<Is = {'N'},IsH = {'N'},[Date]= {">=$(vFrom)<=$(vTo)"},
[order Date]= {">=$(vGFrom)<=$(vGTo)"}> }[Cost]))
The aggr() function needs a field to aggregate by, this is missing in your example
field is cost