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

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

        Hi Oomsen,

         

        That seems not related to the formula. Can you get something in another visual like Table? 

        Can you share a sample file only with limit data that can reproduce the issue?

         

         

        Best Regards,
        Dale