Forum Discussion

Rubal_Islam's avatar
Rubal_Islam
Icon for Helper II rankHelper II
4 years ago
Solved

Automate Trailing 12 months Sales formula

Hi All,   I have two formulas that compare the base period (months) with the trailing 12 months of average energy consumption.   Base formula: July 2017 to  June 2018 (this is always static) Ba...
Need Help
  • VijayP's avatar
    VijayP
    4 years ago

    Rubal_Islam 

    After Date function where you are getting today's Date subtract with 30 get the previous month Date and it should work

VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
4 years ago

Rubal_Islam 

After Date function where you are getting today's Date subtract with 30 get the previous month Date and it should work

  • Rubal_Islam's avatar
    Rubal_Islam
    Icon for Helper II rankHelper II
    4 years ago

    Hi VijayP,

     

    The below formula did the trick and it works like magic.

    Comaprison Energy Usage v2 = CALCULATE(AVERAGE(Data_Source[kWH]),DATESINPERIOD('Date'[Date],DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-30),-1,YEAR))
     
    Thank you very much.

     

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Rubal_Islam Share your Kudos as well by clicking on 👍 Icon!