Forum Discussion
Values derived based on multipe criteria
Hi All, I am new to PowerBi and working on solution wherein I have to determine the value of Country based on Product Category. Let's take an example so that it can be clear:- Year Country ...
I made a PBI file with easy way for you. You can see step by step in the Transform:
https://drive.google.com/file/d/1KWhhYtmb1D1-zLThwT1yCLUW192p5wcY/view?usp=sharing
- Creating a group table
- Join your data with that group
- Group row with sum value
- Pivot column
- Create a average column by DAX
-
Unfortunately, I am not able to view the file through the link. Can you please share the pbix or screenshot of the same
I share a folder again, you can downlaod the Powerbi file:
https://drive.google.com/drive/folders/1qZh8MtEuSvm9F-kERIX3AZ12wxWxpFoU?usp=sharing
