Forum Discussion
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...
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
ryan_mayu
Super User
Super Useryou 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
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
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