Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

EARLIER function not working

I have the following problem:   There is a table column with quarterly metreage called Total. However, it is reported not quarterly but as YTD (Q2 will report Q1+Q2, Q3 will report everything since...
Need Help
Show and Tell
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may refer to below measure. Please let me know if it matches your request or not.

    Year = RIGHT(Drilling[Quarter],4)
    total2 =
CALCULATE (
    SUM ( Drilling[Development] ),
    FILTER (
        Drilling,
        Drilling[Year] = EARLIER ( Drilling[Year] )
            && Drilling[Quarter] <= EARLIER ( Drilling[Quarter] )
    )
)

     

    Regards,

    Cherie

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Anonymous Please post the same data (test data) in copiable format to replicate your issue and will be helpful to suggest any solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Is this one okay?

     

    CompanyFieldTotalExploration/AppraisalDevelopmentQuarterSales Account

    UzenmunaygazUzen49,383049,383Q1 2018UZENMUNAYGAS
    UzenmunaygazUzen114,1730114,173Q2 2018UZENMUNAYGAS
    UzenmunaygazUzen178,7460178,746Q3 2018UZENMUNAYGAS
    UzenmunaygazUzen184,9080184,908Q4 2017UZENMUNAYGAS
    UzenmunaygazUzen139,6320139,632Q3 2017UZENMUNAYGAS
    UzenmunaygazUzen94,355094,355Q2 2017UZENMUNAYGAS
    UzenmunaygazUzen43,720043,720Q1 2017UZENMUNAYGAS
    • v-cherch-msft's avatar
      v-cherch-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous

       

      You may refer to below measure. Please let me know if it matches your request or not.

      Year = RIGHT(Drilling[Quarter],4)
      total2 =
CALCULATE (
    SUM ( Drilling[Development] ),
    FILTER (
        Drilling,
        Drilling[Year] = EARLIER ( Drilling[Year] )
            && Drilling[Quarter] <= EARLIER ( Drilling[Quarter] )
    )
)

       

      Regards,

      Cherie

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi, v-cherch-msft!

         

        I do not not why, but your formula with EARLIER works perfectly fine. Probably, in my formula it had problems with IF or something else.

         

        However, your formula was not what I asked for. I needed to calculate the difference between two quarters, but not the sum of all preceding quarters. Anyway, I was able to adapt your formula to my needs.

         

        Thanks a lot!

         

        Regards,

        Yassaui