Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I will have to do that. I'm trying do a comparison of products, where I need to find my most sold product that wasn't sell the previous year.
May be this
Sum({<ProductName = {"$(=FirstSortedValue({<ProductName = e({<Year = {$(=Max(Year) - 1)}>})>}ProductName, -Ventas))"}, Year = {"$(=Max(Year))"}>}sales)
May be this
Sum({<ProductName = {"$(=FirstSortedValue({<ProductName = e({<Year = {$(=Max(Year) - 1)}>})>}ProductName, -Ventas))"}, Year = {"$(=Max(Year))"}>}sales)
Do you know something about DAX??
DAX? Not sure what that is?
A programming language for Power BI
Nope, no idea sorry
Ok, thanks for all