Forum Discussion

powerbinovice01's avatar
powerbinovice01
Frequent Visitor
2 years ago

Hello Greg,
Thank you for your quick response. I can't believe I watched one of your videos earlier and you are the one to help me with a solution!
Real qucik for clarification purposes, my weekly sales are currently summarized. Are you suggesting I create a new measure, something like Weekly Sales= (SumX('Weekly Sales' [Weekly Sales])
Then proceed and create a new formula for my Difference between Current Week and Prior Week something along the lines of Diff TW and LW = SumX('Weekly Sales',
IF(ISBLANK('Weekly Sales'[Weekly Netchange]) || ISBLANK('Weekly Sales'[Last Week Sales]),
BLANK(),'Weekly Sales'[Weekly Netchange] - 'Weekly Sales'[Last Week Sales]))?


Thank you for your clarification! 

foodd's avatar
foodd
Community Champion
2 years ago

There is no coincidence, as Greg is that awesome...like karma...the good kind.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    foodd Well, I do love talking Power Bi measure totals after all... No really, the first thing I check for when I visit the forums is if there are any measure total questions I can answer... 🙂

     

    And thanks for the kind words!