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
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.