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.
Hi, i am just new in PowerBi but have some experience en Powerpivot
I would like to find out in a table the last use of a Platfom (a long vehicle, with a NumberPlate po Matricula in spanish), and calculate in wich location is .This information comes from a table that shows all movements of the platforms betweens different islands
First, i tried to determine, from each platforms, wich is the number of use. After that i tried to max this use to determine its last service. But i dont know how to select the last PC_centro of this MAx Use
I tried this formulas:
Uso = COUNTROWS(FILTER('tblextraedatospedido';tblextraedatospedido[FechaTope]<=earlier('tblextraedatospedido'[FechaTope])&&'tblextraedatospedido'[_PC_Matricula]=earlier(tblextraedatospedido[_PC_Matricula])))
MaxUso = max(tblextraedatospedido[Uso])
And i tried some different calculation (vlookup to search wich PC-centro match with Max Uso but doesnt works
Thanks
Solved! Go to Solution.
According to your description, you want to get the last use PC_centro within each _po_Matricula. Right?
You can create a measure like below:
Last Use PC_centro = VAR MaxDate = CALCULATE ( MAX ( 'tblextraedatospedido'[FechaTope] ), ALLEXCEPT ( 'tblextraedatospedido', 'tblextraedatospedido'[_po_Matricula] ) ) RETURN CALCULATE ( MAX ( 'tblextraedatospedido'[PC_centro] ), FILTER ( 'tblextraedatospedido', 'tblextraedatospedido'[FechaTope] = MaxDate ), ALLEXCEPT ( 'tblextraedatospedido', 'tblextraedatospedido'[_po_Matricula] ) )
Regards,
According to your description, you want to get the last use PC_centro within each _po_Matricula. Right?
You can create a measure like below:
Last Use PC_centro = VAR MaxDate = CALCULATE ( MAX ( 'tblextraedatospedido'[FechaTope] ), ALLEXCEPT ( 'tblextraedatospedido', 'tblextraedatospedido'[_po_Matricula] ) ) RETURN CALCULATE ( MAX ( 'tblextraedatospedido'[PC_centro] ), FILTER ( 'tblextraedatospedido', 'tblextraedatospedido'[FechaTope] = MaxDate ), ALLEXCEPT ( 'tblextraedatospedido', 'tblextraedatospedido'[_po_Matricula] ) )
Regards,
Many thanks, works perfectly !!!!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |