Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Folks,
I have created a new table from the existing table (Office_Info) using the summarize function. I need to group by for Location and Latest Date. However, the result returned all dates total instead of the latest date. I tried many functions, it still not working. Could I know how to make it happened?
I used
SUMMARIZE('Office_Info',Office_Info[Location],"Latest Date",MAX(Office_Info[Date]),"Total Cost", sum(Office_Info[Total Cost]))
Appreciate any help!
Hi @Anonymous ,
Your formula works well on my sample data. Would you please show us your sample data or pbix file by onedrive for business?
Then we will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Dedmon Dai
@Anonymous
Your formula is correct. can your share the screenshot of the modal and the table. A sample PBIX will be good.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |