Forum Discussion

MRAMS's avatar
MRAMS
New Member
2 years ago
Solved

Formula Help

Hi all,   I am new to Power BI Desktop and have managed to do all other formula's except this one.  If someone could help it would be greatly appreciated.    My formula in excel adds up all the v...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MRAMS 

    You can create a calculated column

    Column = SUMX(FILTER('Table',[FE & Week Start Date MCRQ]=EARLIER('Table'[FE & Week Start Date MCRQ])),[DNU – Unavailable Days MCRQ])

    Output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MRAMS 

You can create a calculated column

Column = SUMX(FILTER('Table',[FE & Week Start Date MCRQ]=EARLIER('Table'[FE & Week Start Date MCRQ])),[DNU – Unavailable Days MCRQ])

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • MRAMS's avatar
    MRAMS
    New Member
    2 years ago

    Hi Anonymous 

    This formula has worked.  Thank you so much for your help.  

    Thanks,

    Michelle

     

    Michelle