Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello, I've looked for answers but can't get what I want. Essentially I need a column that brings the value associated with a previous date onto the current row. The image below shows the requirement. I would like the Tester column to show the previous date's value for each person. The DAX I have has a hard coded date that works for a the most recent dates but as I go down the column it (obviously) starts failing. Any help much appreciated.
Solved! Go to Solution.
Try this
Last Val = CALCULATE(LASTNONBLANK('Table'[Value],'Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Name]),'Table'[Date]<EARLIER('Table'[Date])))
Proud to be a Super User!
@67nmark See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...
Try this
Last Val = CALCULATE(LASTNONBLANK('Table'[Value],'Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Name]),'Table'[Date]<EARLIER('Table'[Date])))
Proud to be a Super User!
Perfect. Thanks so much 🙂
@67nmark , As a measure with date table
Last Day Non Continuous = CALCULATE(Table[Value],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))
as a column
Last day value =
var _max = maxx(filter(Table, [date] < earlier([date]) && [name] = earlier([name])),[date])
return
maxx(filter(Table, [date] = _max && [name] = earlier([name])),[value])
same is discussed in
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
77 | |
60 | |
58 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |