cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Re: Cash Flow

Test = if ( DAY ( MIN ( dimCalendario[data] ) ) = 1; if ( MIN ( dimTipFlu[Open_Bank] ) = 1; SUM ( fatMovi[vlrmovi] ); IF ( MIN ( dimTipFlu[Close_Bank] ) = 1; CALCULATE ( SUM ( fatMovi[vlrmovi] ); ALL ( dimTipFlu ) ); SUM ( fatMovi[vlrmovi] ) ) ); IF ( MIN ( dimTipFlu[Open_Bank] ) = 1; CALCULATE ( TOTALMTD ( SUM ( fatMovi[vlrmovi] ); PREVIOUSDAY ( dimCalendario[data] ) ); ALL ( dimTipFlu ) ); IF ( MIN ( dimTipFlu[Close_Bank] ) = 1; CALCULATE ( TOTALMTD ( SUM ( fatMovi[vlrmovi] ); dimCalendario[data] ); ALL ( dimTipFlu ) ); SUM ( fatMovi[vlrmovi] ) ) ) )

Highlighted
Super User I
Super User I

Re: Cash Flow

Hi @RogerioTortosa,

 

Can you please explain what the formula does and also share a link to down load the pbix file.

 

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Highlighted
New Member

Re: Cash Flow

Rogerio, ficou muito bom seu Fluxo de Caixa. Teria como compartilhar um PBIX modelo?

Highlighted
Helper II
Helper II

Re: Cash Flow

Hi, 

 

The client does not allow the information to be released

But follows tables and relationships

 

relacionamento.pngrelacoes.png

 

Vlr Movi =
if (
    DAY ( MIN ( dimCalendario[data] ) ) = 1;
    if (
        MIN ( dimTipFlu[Open_Bank] ) = 1;
        SUM ( fatMovi[vlrmovi] );
        IF (
            MIN ( dimTipFlu[Close_Bank] ) = 1;
            CALCULATE ( SUM ( fatMovi[vlrmovi] ); ALLSELECTED(dimTipFlu) );
            SUM ( fatMovi[vlrmovi] )
        )
    );
    IF (
        MIN ( dimTipFlu[Open_Bank] ) = 1;
        CALCULATE (
            TOTALMTD ( SUM ( fatMovi[vlrmovi] ); PREVIOUSDAY ( dimCalendario[data] ) );
            ALL ( dimTipFlu )
        );
        IF (
            MIN ( dimTipFlu[Close_Bank] ) = 1;
            CALCULATE (
                TOTALMTD ( SUM ( fatMovi[vlrmovi] ); dimCalendario[data] ); ALLSELECTED(dimTipFlu)
            );
            SUM ( fatMovi[vlrmovi] )
        )
    )
)

Highlighted
Helper III
Helper III

Re: Cash Flow

Hello, I'm new to Power BI. I want to make Cashflow in Power BI. I have some expenses and revenue by date in Power BI - matrix report. It look like this:

 

I have only one table - vmCashPaymentOrders and two important fields: Due_Date and Flow_BGN.

I have put the date in the columns and data in the rows.  I want the following thing:

day by day to see previous day sum(end balance) of fiеld vmCashPaymentOrders[Flow_BGN] as opening balance for the next day.

I aslo made a calendar table called DateTable, with a filed DateTable[Date]

 Balance.jpg

I will try to explain simpler with an excel example:

 

flow2.jpg

 

I want to try your formulas, but I'm not sure if I undestand them correctly, so can you please adopt formula to my tables. I could't understand what is dimTipFlu[Close_Bank] and dimTipFlu[Open_Bank] - data in your table or measures?

Thanks in advance!

Highlighted
Helper II
Helper II

Re: Cash Flow

DimTipFlu.idTipFlu will probably be your PaymentType

In Fact we have the opening and closing movement of the account balance

Highlighted
Helper III
Helper III

Re: Cash Flow

Please explain what are this fields in your tables:

dimCalendario[data]

dimTipFlu

dimTipFlu[Open_Bank]

dimTipFlu[Close_Bank] 

fatMovi
fatMovi[vlrmovi]

 

This fields dimTipFlu[Open_Bank] and dimTipFlu[Close_Bank] confuse me.

I thinks this information, as well as the measure, will give me the answer.

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (925)