Forum Discussion
Data Interpretation error
grouped = Table.Group(#"Sorted Rows1", {"Distribution Point Type", "Residential/ Business", "City", "Feeder", "Serviceable Feeder", "Actual Go-Live", "MonthsSinceGoLive M", "Type", "MonthsSinceGoLiveFormatted M"}, {{"Max Month", each List.Sum([Max Month]), type nullable number}, {"Filter", each List.Sum([Filter]), type number}, {"Sum of Active Customers", each List.Sum([Sum of Active Customers]), type nullable number}, {"Serviceable Units", each List.Sum([Serviceable Units]), type nullable number}, {"Active Customers", each List.Sum([Active Customers]), type nullable number}, {"Premises Ready for Service", each List.Sum([Premises Ready for Service]), type nullable number}, {"Serviceable Pending ROE", each List.Sum([Serviceable Pending ROE]), type nullable number}, {"Serviceable Approved ROE", each List.Sum([Serviceable Approved ROE]), type nullable number}, {"TR", each List.Sum([TR]), type nullable number}})
in cohort analysis q quarter columns there same columns, in POWER QUERY how to solve cohort analysis q table with months columns in quarter table MonthsSinceGoLive M", "MonthsSinceGoLiveFormatted M" by keeping these two columns how to group solve data interpretation in quarter table also other for one property type two units coming for single value.
5 Replies
Hi chaitanya1 - if possible , please share pbix snapshot or file by removing the sensitive data. it helps to analyse.
FYR
HI chaitanya1
I’ve seen this kind of issue before, when you’re working with both month and quarter tables in Power Query, grouping and aggregating can get tricky.
Here’s what usually helps:
-
Sort your data first: Before grouping, sort by your period column (like MonthSinceGoLive) so you get consistent results.
-
Group with clear keys: In your Table.Group step, only use the columns you want as group keys like Distribution Point Type, City, MonthSinceGoLive, etc.
-
Use the right aggregation: For sums, use List.Sum; for unique counts, use List.Count(List.Distinct(...)). Double-check your column types match what you expect (number, text, etc.).
-
Add a quarter column if needed: If you want to group by quarter, create a new column first using Date.QuarterOfYear, then group by it.
-
Try to use a single Date table: If you can, create one Date table with columns for month, quarter, year, etc. and link both your monthly and quarterly data to that. It makes analysis and calculations much smoother and less error-prone.
-
Test with a small dataset: Try your logic on a small set of rows to make sure your grouping and aggregation are working as intended before running it on the full data.
If you can share a sample structure (with sensitive info removed), I can help troubleshoot the exact steps. Hope this helps!
-
Hi chaitanya1 , hello rohit1991 and rajendraongole1 , thank you for your prompt reply!
Is there any progress on this issue?
If you find rohit1991's answer is helpful to you, please remember to accept it.
It will help others who meet the similar question in this forum.
If you have any further related issues, please feel free to reply!
I didn't get proper result because i have separate quarter table as well with month table there are so many issues in qiarter i can't paste all info here due to data protection.
Hi chaitanya1 ,thank you for your feedback.
Could you please share sample data and the table structure without any sensitive information for better troubleshooting?
Thank you for your understanding.
