Forum Discussion

Mond_Ed07's avatar
Mond_Ed07
Frequent Visitor
2 years ago
Solved

Interaction count from Excel to Power BI

Hello, 

I want to replicate the results on what I did in MS Excel into Power BI but Im new to Power BI and dont have much experience on DAX measures yet. 

I want the Interaction Counter to be like the one on the image above.
The image below is the measure that I use and the result that I get.

 


Can somebody help me on how to get the same result on the Excel into Power BI? Any Input will be much appreciated.

Thank you.

 

Need Help

6 Replies

    • Mond_Ed07's avatar
      Mond_Ed07
      Frequent Visitor
      2 years ago

      Thanks for the quick response on my post ryan_mayu. I tried the measure on my end but I got an error.

      my work laptop only have 16GB RAM.
      Is there a work around so that this error wont show up?

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        2 years ago

        maybe you can try to do this in PQ 

        = Table.AddColumn(#"Inserted Date","Rank",each Table.RowCount(Table.SelectRows(#"Inserted Date",(x)=>x[createddate]<[createddate] and x[account]=[account] and x[Date]=[Date]))+1)

         

        pls see the attachment below

  • Mond_Ed07's avatar
    Mond_Ed07
    Frequent Visitor
    2 years ago

    Hello,

    Just finished loading the PQ that you sent and it worked. The loading of the data took almost 2 days to complete since I have 2.7M rows but its finally done and here is the result.


    Big thanks to ryan_mayu for his solution on this thread. You are a life saver. Thank you so much!