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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Mond_Ed07 

    you can try this

    Column = countx(FILTER('Table','Table'[account]=EARLIER('Table'[account])&&int('Table'[createddate])=int(EARLIER('Table'[createddate]))&&'Table'[createddate]<=EARLIER('Table'[createddate])),'Table'[createddate])
     
    pls see the attachment below
     
  • ryan_mayu's avatar
    ryan_mayu
    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!

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

you are welcome