Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have a report of future orders I have created a measure for to obtain the monthly quantity. The data set is connected to my calendar table; however, future dates and monthly totals are not populating in my visuals. Instead, my result is the same total overall quantity repeated across all historical months. 😞
PPO Qty =
SUMX(VALUES('DimDate1'[Month]),CALCULATE (
SUM ( 'PPO Report'[PPO Req. quantity]),
USERELATIONSHIP ( 'PPO Report'[PPO Delivery date], 'DimDate1'[Date] )
))
Will somoene please help? Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @JaclynPugh2022,
For issues corresponding to DAX, I would suggest you post your question in DAX&Commands Tips Forum. There, you would get the help from many community users. And to make your question get answer quickly, it’s better that you provide some sample data in your tables and let the others know their relationships and how you create your visual. Thanks for your understanding!
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Community Support Team _ Caiyun