Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm struggling to add a new column to my dataset using a dax calculated column. I want it to look something similar to this:
Columns A-D are in my dataset, and I want it to have a running count so that every time a distinct email plays for an order, their count will go up by 1. This way, I'll be able to see how many times a product is the first bought item (ie to find out if Apples is the most purchased first item, then bananas etc).
Any help would be super appreciated!
Solved! Go to Solution.
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
Hi,
Write this calculated column formula
Order rank = calculate(countrows(Data),filter(Data,Data[Email]=earlier(Data[Email])&&Data[payment date]=earlier(Data[payment date])))
Hope this helps.
Hi,
Write this calculated column formula
Order rank = calculate(countrows(Data),filter(Data,Data[Email]=earlier(Data[Email])&&Data[payment date]=earlier(Data[payment date])))
Hope this helps.
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |