Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello friends, I am a beginner in power bi and would like help depending on the criteria below
I have the following table:
Based on the last date I need to bring the cost of the cod 104.007.400.004
Result is 06/12/16 - Cost US$ 0.13
Creating a table with unique records
thank you
Hi @Magliasoft,
You poasted the same question here yesterday. Please stick to one thread.
Hi
With this function found here in the forum I solved part of the problem, I need to bring a table field and do the division
Example: cost / table = Percentage
013 / 0.95 = 13.68%
Thank You
.Tabela = ADDCOLUMNS(
SUMMARIZE (
MovimentoEntrada;
MovimentoEntrada[COD_ITEM];
"Data Operacao"; MAX ( MovimentoEntrada[DATA_OPERACAO] )
);
"CIF"; CALCULATE (
SELECTEDVALUE ( MovimentoEntrada[CIF] );
FILTER (
MovimentoEntrada;
MovimentoEntrada[DATA_OPERACAO] = [Data_Operacao]
&& MovimentoEntrada[COD_ITEM] = EARLIER ( MovimentoEntrada[COD_ITEM] )
)
)
)
Not certain I completely understand what you are going for here. You can create a measure like:
FinalCost = CALCULATE(MAX(table[COST]),FILTER(table,Date=MAX(Date)))
You can place this measure into a table visualization along with Cod.
Hello friends, I am a beginner in power bi and would like help depending on the criteria below
I have the following table:
Based on the last date I need to bring the cost of the cod 104.007.400.004
Result is 06/12/16 - Cost US$ 0.13
Creating a table with unique records
thank you
Hi,
So for each Cod, you'd like to determine the cost as on the last date. Am i correct? If yes, then please share the download link of your file.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |