Forum Discussion

svinayagam1984's avatar
svinayagam1984
Icon for Helper I rankHelper I
5 years ago
Solved

Total not showing for Last week

I am trying to compare the current week vs Last week's data at the account level. This is the measure that I created to calculate the previous week's revenue. Last Week = CALCULATE ( SUM ...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    svinayagam1984 try this measure

     

    Last Week new = 
        CALCULATE (
            SUM ( Data[MRR] ),
            DATEADD ( 'Calendar'[Date] , -7, DAY )
        )

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

     

     

  • svinayagam1984's avatar
    svinayagam1984
    5 years ago

    FrankAT 
    This also helped to achieve my result. Thank you!

FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
5 years ago

Hi svinayagam1984 

I think you can do it like this:

 

 

Sum of MRR = SUM(Data[MRR])

Last Week = 
VAR _SUMLastWeek = CALCULATE([Sum of MRR], DATEADD('Calendar'[Date], -7, DAY))
RETURN
    if( [Sum of MRR] = BLANK(), BLANK(), _SUMLastWeek )

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

  • svinayagam1984's avatar
    svinayagam1984
    Icon for Helper I rankHelper I
    5 years ago

    FrankAT 
    This also helped to achieve my result. Thank you!