Forum Discussion
Creating a table showing data from today, this week, month, quarters, and year to date
I'm new to power bi, how would I create a table that looks like this on power bi? Are there any suggestions? It is possible? Thank you!
3 Replies
- BA_PeteSuper User
Hi deepwhiteh2o ,
Yes, it's totally possible and there's a number of ways to do it.
However, in order to help with any of those methods, we need a far better understanding of what you're working with data- and context-wise.
Have a read through this to get an idea of what will help your questions get answered quickly and completely:
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/3250965Pete
- AnonymousNot applicable
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
- deepwhiteh2oRegular Visitor
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