Forum Discussion

dokat's avatar
dokat
Post Prodigy
3 years ago

Creating index column to count rows

Hi I have a .pbix file from direct query data feeds from axure server. I created a report using four tables that are linked in the back end.   The name of the tables are  Activity Status, Group, F...
Need Help
AbhinavJoshi's avatar
AbhinavJoshi
Responsive Resident
3 years ago

Hi dokat. You can create an index column in Power Query M. I hope it helps! 

 

 

dokat's avatar
dokat
Post Prodigy
3 years ago

AbhinavJoshi Thank you for your response. I am connected to the server via direct query to pull the data.I dont have access or visibility to query editor.  Is there a measure i can use, rankx didnt work for me because data is coming from 4 different tables, not from same table.

 

Thanks

  • AbhinavJoshi's avatar
    AbhinavJoshi
    Responsive Resident
    3 years ago

    Hi, I see the situation now. Create a new column in DAX, and enter this formula 

    Index =
        COUNTROWS(
            FILTER(
                ALL('TableName'),
                'TableName'[UniqueKey] <= EARLIER('TableName'[UniqueKey])
            )
        )

    • dokat's avatar
      dokat
      Post Prodigy
      3 years ago

      AbhinavJoshi i have four tables that are linked which table should i reference to? It gives below error message.

       

      EARLIER/EARLIEST refers to an earlier row context which doesn't exist.

      • AbhinavJoshi's avatar
        AbhinavJoshi
        Responsive Resident
        3 years ago

        The report is based on one table or combined of two or more tables?