Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Please can you help me to return the difference between two values within some given dates as below;
So, I would like to substract the previous date value from the current one ie ((Eng FullTime) on the 13/10/2023) - ((Eng FullTime) on the 06/10/2023)
The (Eng Fulltime) is a measure that was calclulated as below;
Solved! Go to Solution.
Hi @Greg_Deckler ,
Many thanks for your assistance!
I have now figured it out using the following;
@Uka 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....
The basic pattern is:
Column =
VAR __Current = [Value]
VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])
VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
__Current - __Previous
Hello @Greg_Deckler ,
The solution did not work for me as I got a wired result as below;
Below is the code that I used;
@Uka Post your sample data as text/table and I'll take a look.
Hi @Greg_Deckler ,
Many thanks for your assistance!
I have now figured it out using the following;
@Uka That works!
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |