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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi atavo,

 

Could you please share a sample and the result you want? It seems you want to sum the balance first rather than find out the min record (a row).

 

Best Regards!

Dale

atavo's avatar
atavo
Helper I
8 years ago

Correct

 

It should first sum the balances and then find the minimum balance. Please see sample below:

 

Sample

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi atavo,

     

    You may refer to my solution here.

     

    Hope this helps.

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