Forum Discussion

Oomsen's avatar
Oomsen
Helper 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
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft 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
Helper 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.