Forum Discussion

Oscar_Mtz_V's avatar
Oscar_Mtz_V
Icon for Kudo Commander rankKudo Commander
6 years ago

Previous non-continuous date value

I have a table from where I want to get the value from the previous available date for the specific Country-Indicator. The previous available date can be a day, month or quarter before. I am a...
DAX
time functions
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Oscar_Mtz_V 

I think a good solution would be to create an Index column via Power QUery Editor mode (Add column pane -> Index column)

Then you will be able to do absolutely the same workaround as for date, but for Index column, like

Previous Value = 
    CALCULATE(
        MAX(Indicators[IndexColumn]),
        ALLEXCEPT(Indicators,Indicators[Country-Indicator]),
        Indicators[IndexColumn]<EARLIER(Indicators[IndexColumn])
    )

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

  • Chris_Botha's avatar
    Chris_Botha
    Icon for Helper I rankHelper I
    5 years ago

    Why do I keep getting a earlier/earliest refers to earlier row contex that does not exist error??  Please help

    • Chris_Botha's avatar
      Chris_Botha
      Icon for Helper I rankHelper I
      5 years ago

      I am trying to do this in Power Pivot.

       

    • miloooooz's avatar
      miloooooz
      Icon for Microsoft Employee rankMicrosoft Employee
      4 years ago

      Did you use measure to create this expression? If so, you cannot use earlier/ealiest function