Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • MarcoPessina's avatar
    MarcoPessina
    6 years ago

    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

MarcoPessina's avatar
MarcoPessina
Resolver IV
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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,

    ReferenceDateValue
    a01/03/2020Yes
    b01/03/2020No
    c01/03/2020No
    d01/03/2020Yes
    e01/03/2020No
    a01/04/2020Yes
    b01/04/2020No
    c01/04/2020Yes
    d01/04/2020No
    e01/04/2020Yes
    f01/04/2020No

    Getting this result though??

     

    Not sure what I'm missing? Many thanks for your help!