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,
DAX-newbie here. I'm losing my mind with this problem, so time to ask help!
I have a data source that has dates, departments and for each date the sum of total value of all transactions. If on Monday the daily transactions are 50 and on Tuesday 30, then in the table Mon is 50 and Tue 80.
What I want to achieve is the daily sales for each department. I'm sure this is easy to achive, but I'm just not getting it. I keep getting stuck on trying to filter by department, and it being impossible because text cannot be used in boolean experssion. I imagine this is DAX101-stuff, so the solution I imagine is simple
Could someone help out?
DATE | DEPARTMENT | TOTALSOLD | DAILYTRANSACTIONS (THIS IS WHAT I WANT) |
1/1/2020 | Sports | 100 | 100 |
1/1/2020 | Clothing | 50 | 50 |
1/1/2020 | Food | 70 | 70 |
1/2/2020 | Sports | 150 | 50 |
1/2/2020 | Clothing | 80 | 30 |
1/2/2020 | Food | 90 | 20 |
1/3/2020 | Sports | 170 | 20 |
1/3/2020 | Clothing | 120 | 40 |
1/3/2020 | Food | 110 | 30 |
Solved! Go to Solution.
Hi @Anonymous
Create rank column =
Hi @Anonymous
IS TotalSold column or measure?
Thanks,
Pravin
Hi @Anonymous
It's a column.
Hi @Anonymous
Create rank column =
That worked perfectly, thank you so much, @Anonymous !
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |