Forum Discussion

ishade's avatar
ishade
Regular Visitor
10 months ago
Solved

Syntax for TOPN on Source Statement of Power Query

Hi, I would like to setup a report to show data of a 'Event' table of Salesforce (Alexis).  I tried to prepare a DataFlow but got empty table but columns and got advise from raja1992 of the possible...
Tips and Tricks
  • Irwan's avatar
    Irwan
    10 months ago

    hello ishade 

     

    i am not sure but seems the last step is not correct.

     

    the M code should put the previous step

    you previous step is Navigation (sorry i dont write it in japanese)

     

    or else, you can use the ribbon button so you dont have to type the code manually (the selection from ribbon should automatically detect the previous step).

     

    Thank you.

danextian's avatar
danextian
Super User
10 months ago

hi ishade 

 

TOPN is a DAX function. You can use Table.FirstN to select the first number of rows. You may also use Table.AddRankColumn to create a rank column then filter the generated rank - this function works similarly with DAX's RANKX.