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.
Hello,
I am running into a bit of trouble creating a report of returned items. The report I am creating will show me the items returned in the last seven and the number of times they have been back historically. It would show something like the following:
Part Number | Serial Number | Date of return | Number of times returned
If I filter the data on the reports page I am left with 1 in the number of times returned. To help compensate for this, I've tried to manipulate a column on the data page to count the number of times a part number (Column 1) and serial number (column 2) appear in my data and use that as a reference number that won't be affected by filtering date.
So far I've tried to create a COUNTROWS function and a MAXX function with no success. I'm still very new to Power BI and DAX. Any help would be greatly appreciated.
Thanks,
Aaron
Solved! Go to Solution.
Hi @ACALDWELL8814 ,
Let me know if you'd like to get the result like this:
Pbix attached; https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/ESvDnzL6vNdGm_xn3lkutF...
Hi,
Share some data and show the expected result.
To clarify, part number and serial number have to match to be a counted value. This is because there are similar serial numbers which have different part numbers and there are similar part numbers with different serial numbers.
Hi @ACALDWELL8814 ,
Please share us your dummy pbix/ simple data and the desired results. that would be easier for us to provide the valuable advice.
Samples are in the following links:
Sample PBIX file:
https://drive.google.com/open?id=1_G-8yNJc_aKVdLVZJhxz3vK4zamsbFSi
Sample Excel Source Data:
https://drive.google.com/open?id=16xgiRpaoxd-fC4MOTgKj_9PbKmCzH5OO
Hi,
What exact result do you want?
The solution provided above works.
Let me know if those files will work, or if you might need additional data for an example.
Hi @ACALDWELL8814 ,
Let me know if you'd like to get the result like this:
Pbix attached; https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/ESvDnzL6vNdGm_xn3lkutF...
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |