Forum Discussion

Oomsen's avatar
Oomsen
Icon for Helper III rankHelper III
7 years ago

Exclude next year

I'm using the function below and would like to exclude values for the coming year. = IF(MIN(Dimdate[Maand van jaar])<=MONTH(TODAY());[Cashflow **bleep**]-[Cashflow];""   The function is calculatin...
Need Help
Oomsen's avatar
Oomsen
Icon for Helper III rankHelper III
7 years ago

That's what i tried but unfortunately it wasn't the solution. As you can see in my example the function works for 2018 december, but not for 2019. So i'm looking for a fix in the formula.  

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Oomsen,

 

Yes, we can see it. Can you share the file and then we can check?

 

Best Regards,
Dale

  • Oomsen's avatar
    Oomsen
    Icon for Helper III rankHelper III
    7 years ago

    I can't share the data because the information is confidentially. I will try to explain the calculation.

    "Beginsaldo" means "Opening balance" and is a running total of alle financial transactions - "cashflow" which is the sum of al financial transactions in the specific month.