Forum Discussion

gco's avatar
gco
Resolver II
6 years ago
Solved

Previous 15 day balance

Hi there,   I am trying to figure out how to get the beginning (15 days ago) and end balance for a specific table.   If i select DepositDate of 11/15/2019 from the slicer.  I would like to get th...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Glen,
    Here you go...PBIX 
    In the message it is right above my name.  The formatting in those messages leave something to be desired.
    Nathaniel

gco's avatar
gco
Resolver II
6 years ago

Nathaniel_C ,

 

Do you think i could add a loop on the totals calculation?  Now that it works, our Marketing department would like to see if i can show a card with the totals for all the deposit dates based on BalanceByType.

 

Here is my calculation that displays the total by type.

 

IF (HASONEVALUE(Table[AccountNumber]),

MAXX (Table, [BalanceByType]),

SUMX (

        SUMMARIZE (

                 Table,

                Table[AccountNumber],

                "max",[BalanceByType]

          ),

         [max]

))

gco's avatar
gco
Resolver II
6 years ago

Hi Nathaniel_C ,

 

Please disregard, i actually put the Total in a table with the deposit date and it showed the total aggregate :).  So i was just overthinking it.

 

Thanks again

 

Glen

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Not that I ever do that!