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.
Calculate group sum whn you have 2 or more categories
Final output: Group sum is calculated based on categories
Process:
1. Upload data > transform data > Add column > Index Column > From 1
you will see index colum in your data, save and close
2. Load data into "Data" colum in power BI,
From "Fileds" > Add "New Column > use Dax code mentioned below
Hi @Reddyp
Thank you for sharing your solution and experience with the community!
Best Regards,
Community Support Team _ Jing
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.