Forum Discussion

markefrody's avatar
markefrody
Post Patron
4 years ago

Define Dynamic Time Values Into Shifts

Hi all, I'm not sure how I can do this in Power BI. Appreciate your kind advice. I have two tables containing the following: Table 1: Manager Schedule Contains the shift schedule and meal (br...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

markefrody While for a different purpose, you essentially need MTBF: 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/339586.
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

  • KNP's avatar
    KNP
    Super User
    4 years ago

    Greg_Deckler - that's a nice pattern. They should turn that into a quick measure. 😉