Forum Discussion

Ganesh1984's avatar
Ganesh1984
Frequent Visitor
5 years ago
Solved

Dax Puzzle

Why does the minimum price in the puzzle column of the Puzzle table indicate $5. Interestingly, if I replace $0 with $1 the answer will be $1. Is this a puzzle?     
Need Help
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    Ganesh1984 ,

    And if you want to revamp your own mentioned DAX so just remove the Price column after ALLEXCEPT. Make it like below:

    Puzzle = CALCULATE(MIN('Table'[Price]),ALLEXCEPT('Table','Table'[Food]))
    So you'll get $0 in output.
amitchandak's avatar
amitchandak
Super User
5 years ago

Ganesh1984 , You are creating a column

 

Try like for Min

minx(filter(puzzle, [food] =earlier([food]) ),[price])

 

For max

maxx(filter(puzzle, [food] =earlier([food]) ),[price])