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