Forum Discussion

jh292's avatar
jh292
Icon for Helper I rankHelper I
4 years ago
Solved

Rolling 3 month average - 3 months

Hi    I created the following measure (no doubt with help) which works perfectly for a rolling 3 month average;   3 Month Average Rolling Rev = divide(calculate([Total Sell Cost],datesinperiod('C...
Need Help
  • jh292's avatar
    jh292
    4 years ago

    this is how I have done it;

     

    3 month rolling previous 4,5,6 months = divide(
    CALCULATE(sumx('salesTable',if(DATEDIFF('salesTable'[date],today(),month) <= 6 &&
    DATEDIFF('salesTable'[date],TODAY(),MONTH) >= 4, 'salesTable'[Selling Cost],0))),3,0)
jh292's avatar
jh292
Icon for Helper I rankHelper I
4 years ago

this is how I have done it;

 

3 month rolling previous 4,5,6 months = divide(
CALCULATE(sumx('salesTable',if(DATEDIFF('salesTable'[date],today(),month) <= 6 &&
DATEDIFF('salesTable'[date],TODAY(),MONTH) >= 4, 'salesTable'[Selling Cost],0))),3,0)
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    I need Netflix for free for 3 months