Forum Discussion
Creating a table showing data from today, this week, month, quarters, and year to date
Yes, please us know how your original data is structured, especially the dates, and we will solve it for you. It would be best to paste a sample table of your data (as text), so we can ingest it into Power Query.
But indeed, there are many, many ways to do it, and we all want to help you the fastest--and with the most efficient answer. We try to outdo each other sometimes because that's how much we LOVE Power Query--you benefit by getting to best solution.
--Nate
Hi, thanks for helping!
Date | Category | Issue | Cost of Quality |
10/2/2023 | Customer Complaint_C | Moisture | |
10/17/2023 | MRB | Fabric/Weave Defects | $500 |
12/19/2023 | Customer Complaint_B | FOD (Loose Fibers) | $0.00 |
11/7/2023 | Customer Complaint_B | Roll Length (Short) | $400 |
12/19/2023 | Customer Complaint_B | FOD & Shipping Damage to Boxes | $0.00 |
11/7/2013 | Customer Concern | Incorrect Fiber Shipped | $0.00 |
11/8/2023 | MRB | Incorrect Fiber used | $600 |
11/8/2023 | MRB | Numerous MRB Items in Production | $1200 |
11/8/2023 | Customer Complaint_B | Leno Defect | $0.00 |
11/21/2023 | MRB | Incorrect Roll Length (Short) | $0.00 |
11/27/2023 | MRB | Incorrect Lot Number | $0.00 |
1/9/2024 | Customer Feedback | Compaction Issue |
It kind of looks like this