Forum Discussion

Saxon10's avatar
Saxon10
Post Prodigy
3 years ago

Index Direct Query

The source of data came from SQL server and I am not able to change the data or modify any new columns in SQL query. How can I create a Index in direct query method.  I can't use the power query op...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

What are you trying to achieve with that index? Can you add the index in the SQL source?

  • Saxon10's avatar
    Saxon10
    Post Prodigy
    3 years ago

    lbendlin,

     

    Thanks for your reply. I am trying to countif and countifs based on the index column. Please refer the snapshot 

     

    I am using the following formula in Excel COUNTIF($A$2:$A2,A2) and COUNTIFS($A2:$A2,A2,$B$2:$B2,B2). I like to apply the same login in power bi but unable to achieve without index column.

    Is that's anyway I can apply the above mentioned formula in power bi without index column?

    I am unable to add index in SQL source. 

    Can you assist me.