Forum Discussion
DAX formula for MODE giving errors
Hello All, I am new to PowerBi and working on a DAX formula to calculate Mode of my data set. (see attached) I got following formula from one of the sites, which works correctly exc...
Found the problem. It was not an error, but because that column had 2 modes, DAX was picking up the max among the two. Excel by default picks up minimum of the two. I just updated the formula as Maxx(firstnonblank(mytable1,[value]),[value]) and it now gives same result as excel file.
Found the problem. It was not an error, but because that column had 2 modes, DAX was picking up the max among the two. Excel by default picks up minimum of the two. I just updated the formula as Maxx(firstnonblank(mytable1,[value]),[value]) and it now gives same result as excel file.