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 calculating my cashflow openingbalance. I would only like to see a openingsbalance for months in the past. That is why december is empty. But when i filter on 2019 all values except december are presented. 

 

 

Need Help

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    sample data please

  • Oomsen's avatar
    Oomsen
    Helper III
    7 years ago

    This is the 2018 data. I would like to create the samen overview for 2019. All measures are working except the opening balance (beginsaldo).

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Oomsen,

       

      Should it be 0 for the year 2019? Please try the formula below.

       

      a =
IF (
    MIN ( Dimdate[Maand van jaar] ) <= MONTH ( TODAY () )
        && MIN ( Dimdate[Year] ) <= YEAR ( TODAY () );
    [Cashflow **bleep**] - [Cashflow];
    ""
)

       

      Best Regards,
      Dale

      • Oomsen's avatar
        Oomsen
        Helper III
        7 years ago

        It should be "0" in 2019 indeed. I have tried this function but power bi say: "the visual element can not be opened".