Answers for "Rolling 12 Month Sales Formula"

0

Rolling 12 Month Sales Formula

Rolling 12 Months Profit = 
    CALCULATE ( [Profit],
              DATESBETWEEN('DateTable'[DateColumn] ,
              NEXTDAY(
                     SAMEPERIODLASTYEAR(
                               LASTDATE(DateTable'[DateColumn] ))),
              LASTDATE('DateTable'[DateColumn])))
Posted by: Guest on August-24-2021

Browse Popular Code Answers by Language