Discussion
Everything happening across the datasets. Open a question to reply.
-
Reply DD-TRF-001-Q005
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…”
-
Reply DD-TRF-001-Q005
Amounts stored as text
“Its done Thank you. I forgot and later remembered to check the same from Data transformation at scale manual”
-
Reply DD-TRF-001-Q005
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…”
-
Reply DD-PRC-003-Q001
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…”
-
Reply DD-RET-002
Inventory, Promotions and Product Profitability
“Attached is my solution, and a writeup on my approach. Thanks”
-
Reply DD-PRC-003-Q001
Group supplier spend in 2025
“236397332.6”
-
Reply DD-RET-002
Inventory, Promotions and Product Profitability
“Hello,,, please explain your query in details,, Tks”
-
Reply DD-RET-001-Q022
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…”
-
Reply DD-RET-001-Q022
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…”
-
Reply DD-HLT-001
Outpatient Service Performance
“Net change was matching”
-
Reply DD-RET-001-Q019
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…”
-
Reply DD-RET-001-Q001
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…”
-
Reply DD-RET-001-Q005
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 …”
-
Reply DD-RET-001-Q011
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 …”
-
Reply DD-MFG-001-Q003
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…”
-
Reply DD-MFG-001-Q021
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…”
-
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…”
-
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 …”
-
Reply DD-MFG-001-Q008
Total downtime minutes
“Let me look into your query and get back to you.”
-
Reply DD-MFG-001-Q008
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…”
-
Reply DD-MFG-001-Q021
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…”
-
Reply DD-MFG-001-Q003
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 …”
-
Reply DD-RET-001-Q019
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…”
-
Reply DD-RET-001-Q011
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…”
-
Reply DD-RET-001-Q005
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…”
-
Reply DD-RET-001-Q001
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…”