Forum Discussion
Solved
need help with DAX calculation
Hi everyone, need help here! I have a trip record table, where it shows DATE, PLATE, TRIP_CODE and I want that when selecting a date (in a filter visual) it results in the list of vehicles that t...
Hi Gonast
If you want a measure, check this:
ULTIMA FECHA = VAR vDate = SELECTEDVALUE(SalidasLima[FECHA]) RETURN CALCULATE(MAX(SalidasLima[FECHA]), ALLEXCEPT(SalidasLima,SalidasLima[PLACA1]),SalidasLima[FECHA]<vDate)Model:
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi Gonast
If you want a measure, check this:
ULTIMA FECHA =
VAR vDate = SELECTEDVALUE(SalidasLima[FECHA])
RETURN
CALCULATE(MAX(SalidasLima[FECHA]), ALLEXCEPT(SalidasLima,SalidasLima[PLACA1]),SalidasLima[FECHA]<vDate)
Model:
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Thanks you very much!