Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Powerbi Find most common value

Hey i have a issue with powerbi that i cant figure out. The data looks like this Suplier: |     Item no: | T00001  |     STD0001 T00002 |      STD0564 T00003 |     STD06646 M00005 |    STD05454...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    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
    )
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.