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
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.
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.
Proud to be a Datanaut!
You poasted the same question here yesterday. Please stick to one thread.
With this function found here in the forum I solved part of the problem, I need to bring a table field and do the divisionExample: cost / table = Percentage013 / 0.95 = 13.68%
.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] ) ) ))
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.