Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi everybody, I have a calculated value on Dax, but it calculates the value between the current fuel fill and the next one. I want to calculate the value between the current fuel fill and the previous one. Can abybody help me with this, please?
The Dax formula used is here, and attachet below.
Thank you
Solved! Go to Solution.
Hi @Anonymous I found the solution for this case, it was:
Hi @renanc ,
Please share some sample data so that we could test the formula on it.
Best Regards,
Jay
Hi @Anonymous I found the solution for this case, it was:
Hi @johnt75, actually it did not work. In the new column (Diferenca KM 2), the values are negative values of those we have in Digite a KM. Probably the term inside
CALCULATE ( MIN ( [Digite a KM] ), FILTER ( ALL ( fChecklists ), fChecklists[IdChecklist] = _max && fChecklists[DescPlaca] = EARLIER ( [DescPlaca] ) && fChecklists[IdQuestionario] = EARLIER ( [IdQuestionario] ) )
is returning 0 or a null value, and then subtracting [Digite a KM].
Thank you for your help
You can try
Diferenca KM =
VAR _max =
CALCULATE (
LASTNONBLANK ( fChecklists[IdChecklist], 0 ),
FILTER (
ALL ( fChecklists ),
fChecklists[IdChecklist] < EARLIER ( [IdChecklist] )
&& fChecklists[DescPlaca] = EARLIER ( [DescPlaca] )
&& fChecklists[DtCadastro] >= EARLIER ( [DtCadastro] )
&& fChecklists[IdQuestionario] = EARLIER ( [IdQuestionario] )
)
)
RETURN
CALCULATE (
MIN ( [Digite a KM] ),
FILTER (
ALL ( fChecklists ),
fChecklists[IdChecklist] = _max
&& fChecklists[DescPlaca] = EARLIER ( [DescPlaca] )
&& fChecklists[IdQuestionario] = EARLIER ( [IdQuestionario] )
)
) - [Digite a KM]
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |