Forum Discussion

JanoLehocky's avatar
JanoLehocky
Icon for Helper I rankHelper I
5 years ago
Solved

Help with identifying increase within a date range group

Good evening Power BI community,   Hoping someone can help me with this challenge that I would like to proper and elegant solution for.    I am starting with data that looks like this: Person...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

JanoLehocky Maybe:

PROMO STATUS Column =
  VAR __Previous = MAXX(FILTER('Table',[Personnel no.] = EARLIER([Personnel no.] && [Basic Pay Record Start Date] < EARLIER([Basic Pay Record Start Date])),[Basic Pay Record Start Date])
  VAR __PreviousBand = MAXX(FILTER('Table',[Personnel no.] = EARLIER([Personnel no.] && [Basic Pay Record Start Date] = __Pevious),[Salary Band])
RETURN
  IF(__PreviousBand > [Salary Band],"Promotion",BLANK())

PROMO CYCLE =
  IF(MONTH([Basic Pay Record Start])=3 && [PROMO STATUS] = "Promoted","On Cycle",BLANK())
JanoLehocky's avatar
JanoLehocky
Icon for Helper I rankHelper I
5 years ago

Greg_Deckler - Forgive me I am not entirely sure how to use your solution. Where do I paste this code in? Using the advanced editor? 

 

Thank you 

Jano

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    JanoLehocky No, I wasn't paying attention and gave you a DAX solution so you can't do that in Power Query, just as a DAX calculated column.