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!
