Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
you can try this
Proud to be a Super User!
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
Proud to be a Super User!
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!
you are welcome
Proud to be a Super User!
you can try this
Proud to be a Super User!
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?
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
Proud to be a Super User!
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
86 | |
79 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |