Forum Discussion

Oscar_Mtz_V's avatar
Oscar_Mtz_V
Kudo 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
Community 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
Helper 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
    Helper I
    5 years ago

    I am trying to do this in Power Pivot.

     

  • miloooooz's avatar
    miloooooz
    Microsoft Employee
    4 years ago

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