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 requiring a way to group the number of companies by week so that any number = 1 interaction for that week ....
see
Row Labels | Count of adnumbr |
ABBEY ROAD CAR SALES | |
14 | £1 |
41 | £1 |
43 | £1 |
45 | £1 |
andy briggs | £1 |
AUTO IMAGE CARS LTD | £33 |
CARAT - A TRADING DIVISION OF AEGIS MEDIA | £7 |
CJS CAR SALES | |
43 | £1 |
DSG GROUP LIMITED | £3 |
EMLYN STREET TYRES | £1 |
ENVIROCASTING LTD | £12 |
HANDMARK ENGINEERING | |
6 | £2 |
LONGLANE GARAGE | £5 |
For handmark engineering in week six it counts it as two becasue there are two seperate ad numbers in the transaction table.
The week is in the calendar table and it is joined by the date in the transaction table. I need to somehow identify that there is only one interaction for that week... Any ideas?
Calendar table
Date | Finweek | Week of Year| Month Year
Transaction table
Date | Company Name | Title | Sale Price
Solved! Go to Solution.
HI @Anonymous,
If these tables contains the relationship, you can direct drag 'company name' and 'week of year' to rows field of matrix, then drag sale to value field and swith the summary mode to sum. It will auto summary sale value by company name and week number.
Regards,
Xiaoxin Sheng
HI @Anonymous,
If these tables contains the relationship, you can direct drag 'company name' and 'week of year' to rows field of matrix, then drag sale to value field and swith the summary mode to sum. It will auto summary sale value by company name and week number.
Regards,
Xiaoxin Sheng
Thanks will give a that a try!
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |