Direct query - add values from other table to the main table with conditions
Hi, I have created model in "direct query" mode, I dont have experience with it. (I normaly use add Column with combination formulas Calculate + Allexept... now it doesnt work) I need to add values from one column in "table B" to the "table A" for Column xID. I have this conditions: max values from "Column Order" -1 for each Column xID determine value in Column Personal ID in Table A, which is key for connect to Table B. The unique key for this situation in Table A is combination Column xID with Column Personal ID (because values from Personal xID can be repeated). I need to add value from Table B - Column Name to the new Column in Table A (in need can by measure), duplicated for same Column xID values. (Table A has over 23 milions rows)
How to replicate Parameters (tableau) in Power BI?
This is the parameter created in Tableau and I want to create something similar in Power BI, as this parameter is then used to calculate a field called PLAN as below: What is the best way I can achieve this in Power BI? I want to use this field "Plan" (sum) as my column value.
Cumulative sum measure filtered by conditions on two diferente tables
Hi guys, Need a bit of a help here with a dax measure. For context, here's a printscreen of my current data model. If I want to calculate the stock value in a given period I can use the following measure: Stock = CALCULATE( SUM(MaterialMovimento[Quantidade]); FILTER(ALL(Datas[Data]); Datas[Data] <= MAX(Datas[Data])) ) But the problem starts when I want to calculate the stock value in given period of time, but just for materials which are slow movers. In other words, materials that don't have any sale in the past 3 months for any given date. I've tried to create a measure to plot the stock value of slow movers over time but it's just not working. Here's the dax measure I'm unsuccesfully working on: SlowMoversStock = VAR SlowMovers = CALCULATETABLE(Material; FILTER(ALL(ClienteFaturacao); ClienteFaturacao[DataCriacao] <= DATEADD(Datas[Data]; -3; MONTH))) Return CALCULATE( SUM(MaterialMovimento[Quantidade]); FILTER(ALL(Datas[Data]); Datas[Data] <= MAX(Datas[Data])); INTERSECT(Material; SlowMovers) ) Unfortunatelly, with this measure I'm not able to get any value. All the graphics shown below were ploted with yaxis = SlowMoversStock and xaxis = Datas[Data] I think the problem it's somehow related with the date filtering (probably because of the relationships on the data model) I'm trying to perform when creating the calculated table to get the materials which are slow movers. You can see that I filter with a fixed date, the graphic shows values, as you can see in the code and image below. SlowMoversStock = VAR SlowMovers = CALCULATETABLE(Material; FILTER(ALL(ClienteFaturacao); ClienteFaturacao[DataCriacao] <= DATE(2019; 7; 7))) Return CALCULATE( SUM(MaterialMovimento[Quantidade]); FILTER(ALL(Datas[Data]); Datas[Data] <= MAX(Datas[Data])); INTERSECT(Material; SlowMovers) ) Any help would be appreciated. Thanks in advance!
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
