Forum Discussion
Powerbi Find most common value
In that case create a new calculated column and paste that DAX formula into it.
This formula;
Common Supplier =FIRSTNONBLANK(TOPN(1,VALUES(Table'[Item no.]),RANKX(ALL('Table'[Item no.]),[Supplier Count],,ASC)),1)
In that case you can go to Power Query Editor and remove duplicates.
Home->Transform Data->Right Click on the Column->Remove Duplicates->File->Close and Apply.
Regards,
Sanket Bhagwat
Still how do i show the most frequent value in the data of Power Query cause i wanna use it for later so i somehow wanna have the most reacuring ITEM NO data in my queries.What function do i call in Power Quary Custom Table so i can get the same result that you did.
You cannot use DAX in Power Query Editor.
You have to first remove duplicates using Power Query Editor and then apply the measure in power BI Desktop.
This is how the full query looks and i need to update it so that next to it we have most frequent values(Most common Item no for Source number).
In that case create a new calculated column and paste that DAX formula into it.
This formula;
Common Supplier =FIRSTNONBLANK(TOPN(1,VALUES(Table'[Item no.]),RANKX(ALL('Table'[Item no.]),[Supplier Count],,ASC)),1)