Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
And if you want to revamp your own mentioned DAX so just remove the Price column after ALLEXCEPT. Make it like below:
@Ganesh1984 , that's wierd.
I tried the same DAX interestingly I'm getting different answer.
Regards,
Manikumar
Proud to be a Super User!
Try this DAX column:
And if you want to revamp your own mentioned DAX so just remove the Price column after ALLEXCEPT. Make it like below:
@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])
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |