mappings

4 Topics

Data Mapping based on other table's field name
Hi Community ! As my BI-experiences are more with other tools than PowerBI, I am struggling on this one as I think it should work somehow: I do have two tables: Data DataID Column2 Column3 Column4 1 Text123 <null> Text789 2 <null> Text456 Text789 Scoring ScoringID DataColumn Score 1 Column2 10 2 Column3 5 3 Column4 20 My issue: I want to apply a scoring for DataQuality for one of my tables. Meaning: I have a defined Scoring table applying a score per specific column that should be applied if the datafield is not null. Based on the example posted, DataID 1 will have a score of 30, while DataID 2 should have a scoring of 25. So I at least think, that I need something like if(Data.ColumnName() = [Scoring].[DataColumn], if(isnull([Data].[Column2]),0,1)*[Scoring].[DataColumn]) However, I am stuck due to the lack of PowerBI knowledge as I do not know where exactly to apply and as well how to get this comparision with the field name. Hope someone can help me out here 🙂 Also, if there are any other or built-in options to do this - very appreciated!
Solved
CoTheiss
3 years ago Place DAX Commands and Tips
1KViews
0likes
3Comments
DAX Measure to Check Tag From Different Table
Hi all, I am trying to solve a problem with relationships and column mapping from other table. I have two tables, both containing hundreds of rows of data. I have created a simple illustration data below. Table1 is considered as Main Data table, whereas Table2 as Product Code mapping Table: I would like to add Product Code column to Table 1. So basically, I am looking for a solution (DAX, Relationships, etc.) to check if Product in Table2 is included in Product of Table1. If it is true, then it should map to the correct Product Code. I have tried to play with relationships, but it does not map correctly. As a result, all "Bert" Products should have a code FEB, "WayX" Products should have a code DCA etc... A desired outcome example: Any suggestions? Best Regards, Jere
Solved
jereaallikko
4 years ago Place DAX Commands and Tips
2.1KViews
0likes
7Comments
Power BI Bing Map Locations
Hi all, I have a list of addresses that I am mapping with the default bing maps in Power Bi Desktop version 2.8..5831.1181. My issue is that some addresses does not exist. So they do not show in the map as expected, but I would like to count the addresses that it's not mapping. Anyone have any suggestion of how can I count those addresses to be reported. Thanks.
Anonymous
5 years ago Place Custom Visuals Development Discussion
950Views
0likes
0Comments
DataViewMapping Conditions Not Working as Expected
I'm having some trouble with setting up a condition containing a minimum requirement. Example: "conditions": [ { "x": { "max": 1 }, "y": { "min": 2 } } ], The goal is that until the user has mapped exactly one X and two or more Y fields, they will continue to see an error like this: What actually happens is that you can't map any fields at all. We could set up multiple conditions as "stepping stones" to get to the condition shown above, but that would completely defeat the purpose. The goal here is to display the included error message until the user has mapped all the necessary fields. Is this possible, or will we need to implement our own input validation and error display? powerbi-visuals-api: 2.5.0 powerbi-visuals-tools: 3.0.12 powerbi-visuals-utils-dataviewutils: 2.1.1
mattapq
7 years ago Place Custom Visuals Development Discussion
1.8KViews
0likes
1Comment