Forum Discussion

atavo's avatar
atavo
Helper I
8 years ago
Solved

Minimum value at different granularity

Hi   I have a fact table with the following columns:   Date, CustomerID, BankAcctNo, Balance   The fact table basically captures the balances of customers' various deposit accounts daily.   P...
Need Help
  • atavo's avatar
    atavo
    8 years ago

    Hi Ashish,

     

    Thanks for your kind assistance,

     

    this is exactly what I was after. For the benefit of other viewers, here is the measure/ solution:

     

    MINX(

    SUMMARIZE('calendar',

    'calendar'[Date],

    "ABCD",

    SUM(Table1[Balance])),

    [ABCD])

     

    Alfred

    Alfred

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Drag CustomeID column to the visual and use th efollowing measure

 

=CALCULATE(MIN(Data[Balance]),ALL(Data[BankAcctNo]))

 

Hope this helps.

atavo's avatar
atavo
Helper I
8 years ago

Hi Ashish

 

Thanks for the assistance but this is not the solution I am after...the measure should first sum the deposit balances by customer by day i.e. (Data grouped by Date and customer and the respective balances are summed)...only then that you determine the minimum balance.

 

Alfred