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 MarcoPessina ,
that table is exactly what I'd like, but after trying the measures it wasnt giving me right figures. I created a new small table to test it on too, as below,
| Reference | Date | Value |
| a | 01/03/2020 | Yes |
| b | 01/03/2020 | No |
| c | 01/03/2020 | No |
| d | 01/03/2020 | Yes |
| e | 01/03/2020 | No |
| a | 01/04/2020 | Yes |
| b | 01/04/2020 | No |
| c | 01/04/2020 | Yes |
| d | 01/04/2020 | No |
| e | 01/04/2020 | Yes |
| f | 01/04/2020 | No |
Getting this result though??
Not sure what I'm missing? Many thanks for your help!
Hi Anonymous ,
check this out:
https://drive.google.com/file/d/1WD35GYlk-SWcSC-JRz8Gywbiyg1U_-Op/view?usp=sharing
Cheers,
Marco