Skip to main content

Discussion

Everything happening across the datasets. Open a question to reply.

  1. Amounts stored as text

    “Hello, Well done on solving it yourself. Going back to the manual is exactly the right habit. Could you share what fixed it, so othe…”

    admin_findi360 · 3 days ago

  2. Amounts stored as text

    “Its done Thank you. I forgot and later remembered to check the same from Data transformation at scale manual”

    amnahafeez · 3 days ago

  3. Amounts stored as text

    “My dax is not producing the correct number which is 811. Mine is 552. Can you please spot the error Text amount = CALCULATE( [No. o…”

    amnahafeez · 3 days ago

  4. Group supplier spend in 2025

    “Thanks for posting, justedd! Not quite yet: your total is about 24% below the expected answer, so something is being left out. Three things…”

    admin_findi360 · 6 days ago

  5. Reply DD-RET-002

    Inventory, Promotions and Product Profitability

    “Attached is my solution, and a writeup on my approach. Thanks”

    ademola · 6 days ago

  6. Group supplier spend in 2025

    “236397332.6”

    justedd · 6 days ago

  7. Reply DD-RET-002

    Inventory, Promotions and Product Profitability

    “Hello,,, please explain your query in details,, Tks”

    admin_findi360 · 3 weeks ago

  8. Best margin month

    “Hi, your margin formula is right. The issue is in the pivot. You worked out a % for each transaction and the pivot averaged them, so a smal…”

    admin_findi360 · 4 weeks ago

  9. Best margin month

    “For this question, my answer is not matching with the answer mentioned in the solution. My answer is Feb 2026 and %age is 30.26. In the sug…”

    abubakar · 4 weeks ago

  10. Reply DD-HLT-001

    Outpatient Service Performance

    “Net change was matching”

    amnahafeez · 4 weeks ago

  11. Peak sales month

    “Yes. Don’t build the month in the fact table. The dataset has a DimDate table with a YearMonth column already, related on DateKey. Put Di…”

    admin_findi360 · 4 weeks ago

  12. Total net sales for the period

    “Good question to ask first. You don’t need to subtract anything: the fact table already carries NetSalesSAR, which is sales after discoun…”

    admin_findi360 · 4 weeks ago

  13. Gross margin earned

    “Use net sales. Margin is what the business actually earned after giving the discount, so net sales less cost of goods. The fact table also …”

    admin_findi360 · 4 weeks ago

  14. Top store by net sales

    “Nice and quick. One check: the bar chart should show StoreName from DimStore, through the relationship on StoreID, rather than the StoreID …”

    admin_findi360 · 4 weeks ago

  15. Total scrap quantity

    “Yes. Don’t build the month in the fact table. The dataset has a DimDate table with a YearMonth column already, related on DateKey. Put Di…”

    admin_findi360 · 4 weeks ago

  16. Monthly trend of scrap quantity

    “Good instinct to question a spike before reporting it. It’s real. That month also has one of the highest order volumes, so more orders me…”

    admin_findi360 · 4 weeks ago

  17. Reply DD-HLT-001

    Outpatient Service Performance

    “Hi, great work, your model is right and you’re very close. The only issue is ABS() in YOY Change. Department 3 actually fell: 330 enco…”

    admin_findi360 · 4 weeks ago

  18. Reply DD-HLT-001

    Outpatient Service Performance

    “Reference Q# 28 What i am doing wrong here set the admissiondateKey column as admission date and changed it type to date then i added a …”

    amnahafeez · 4 weeks ago

  19. Total downtime minutes

    “Let me look into your query and get back to you.”

    data_dare_community · 1 month ago

  20. Total downtime minutes

    “Did a simple sum and my number came out quite big. Is downtime recorded per order or per shift? Because if it is per shift then we may be d…”

    zainab_fatima · 1 month ago

  21. Monthly trend of scrap quantity

    “One month is much higher than all the others. Did anyone else see the same spike? Trying to understand if it is a data problem or a real th…”

    ahmad · 1 month ago

  22. Total scrap quantity

    “Sum of the scrap column, done in one minute. But then I thought — is scrap already removed from produced quantity, or is produced before …”

    ahmad · 1 month ago

  23. Peak sales month

    “My date column is a full date like 01-03-2025. I made a separate month column and then found the highest month. Is there a shorter way in P…”

    ayesha · 1 month ago

  24. Top store by net sales

    “Made a simple bar chart, store on one side and sales on other side, top store came out clearly. Took 5 minutes only. Anyone got a different…”

    ayesha · 1 month ago

  25. Gross margin earned

    “Margin is sales minus cost, that part is easy. My confusion is should I use net sales or gross sales here. Both give different answer. What…”

    hamzaaa · 1 month ago

  26. Total net sales for the period

    “I opened this file for the first time. There is a sales column and a discount column both. For total net sales do we take sales as it is, o…”

    ayesha · 1 month ago