Forum Discussion
Monthly difference
Hoping someone can help! Each month I receive a finance file, the total number of rows varies each month. The two columns of interest are financial_ref (which is a unique identifier for each month, t...
Hi Anonymous ,
assuming you have a Date table you can try these measures:
Total Outcome = CALCULATE( COUNTA(Sheet1[Outcome]))Total Outcome Prev Month = CALCULATE( [Total Outcome],DATEADD('Date'[Date],-1,MONTH))% Monthly Change = DIVIDE( [Total Outcome] - [Total Outcome Prev Month],[Total Outcome Prev Month], 0)Hope it helps.
Cheers,
Marco
Hi Anonymous ,
check this out:
https://drive.google.com/file/d/1WD35GYlk-SWcSC-JRz8Gywbiyg1U_-Op/view?usp=sharing
Cheers,
Marco
Hi Anonymous ,
assuming you have a Date table you can try these measures:
Total Outcome = CALCULATE(
COUNTA(Sheet1[Outcome]))Total Outcome Prev Month = CALCULATE(
[Total Outcome],DATEADD('Date'[Date],-1,MONTH))% Monthly Change = DIVIDE(
[Total Outcome] - [Total Outcome Prev Month],[Total Outcome Prev Month], 0)
Hope it helps.
Cheers,
Marco