![]() ![]() My amateur idea was to create new dataset with data only for that one country which I need in those calculations, but I was not able to combine 2 datasets in one table. And another one is how to get data for one specific country so I can use it in my calculations for those rows. ![]() There are 2 problems here: How to create those rows, which would be based on already existing row names, so basically duplicating certain row names with addition of some sort of "flag" (e.g. So there would be always Germany data involved in the calculations, cause it's percentage Germany data. Calculation might be something like this: (Data_column_x for US)/(Data_column_x for Germany) or (Data_column_x for India)/(Data_column_x for Germany). So it would be named something like "US" and "Germany" For those rows I need to calculate the values. Now, what I need is: for some countries I need rows which would be basically the same country name, but with some kind of % values. Power BI Mobile Power BI Desktop: It is a Windows desktop application (Report Authoring Tool) which Lets you build queries, models and reports that visualize data. I have a table where I have multiple columns with data(numbers) and one column based on which I'm summing those numbers. I've been working with Report builder for 2 days, so please be kind if my question is stupid. I'm not sure if the name of this post is descriptive enough, but I'll try to describe my problem better here. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |