Forum Discussion

deepwhiteh2o's avatar
deepwhiteh2o
Regular Visitor
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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

    • deepwhiteh2o's avatar
      deepwhiteh2o
      Regular 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