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

atavo's avatar
atavo
Helper I
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 atavo,

     

    If my reply helped, please give me kudos and mark my reply as Answer.