Interaction count from Excel to Power BI

[Mond_Ed07]

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.

[ryan_mayu · Accepted solution]

@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

[Mond_Ed07]

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]

you are welcome

[ryan_mayu · Accepted solution]

@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

[Mond_Ed07]

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 · Accepted solution]

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]

I'll try this one on PQ. Still loading since the table that Im using has 2.7M rows on it. This might take a while to load but I'll update on the results once it is done.

I'll keep you posted @ryan_mayu . Thanks a bunch! Have a great day!