Forum Discussion
Aggregate Value
Where am I going wrong ? I want to filter the quantity sold field month wise but its showing me an aggregate value.
nishantr can you make sure the date column in your transaction table doesn't have a time portion in it, is it a date/time column or just a date? Can you share the preview of transaction date data in Power Query?
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡