Forum Discussion

blazko's avatar
blazko
Icon for Helper III rankHelper III
9 years ago
Solved

Daily max calculation, by months

Hi, I have a problem with calculating max daily sum. Somehow it calculates it monthly. Here's how it looks like:   I have tried with solution from this topic: Desktop/MAX-of-SUM-values   ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi blazko,

    In the given thread, the week column and Amount are in one table. While based on your DAX formula, your data and value in different table. You want to create a measure or calculated column? What do your resource table look like? 


    Based on my understanding, you'd better get the amount in 'relacje_data' table using the formula:
    amount=SUM(RELATED(tabela_linie[amount]))

    Then create a measure use the formula bolow. 

    result=MAXX(SUMMARIZE(relacje_data,relacje_data[Date].[day]),"Amount",SUM(relacje_data[amount])),[Amount])


    Finally, you can create a table visual, add the relacje_data[Date] and [result] as value fields.

    Best Regards,
    Angelia


v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi blazko,

In the given thread, the week column and Amount are in one table. While based on your DAX formula, your data and value in different table. You want to create a measure or calculated column? What do your resource table look like? 


Based on my understanding, you'd better get the amount in 'relacje_data' table using the formula:
amount=SUM(RELATED(tabela_linie[amount]))

Then create a measure use the formula bolow. 

result=MAXX(SUMMARIZE(relacje_data,relacje_data[Date].[day]),"Amount",SUM(relacje_data[amount])),[Amount])


Finally, you can create a table visual, add the relacje_data[Date] and [result] as value fields.

Best Regards,
Angelia


cjulianm's avatar
cjulianm
Icon for Advocate I rankAdvocate I
8 years ago

Hi Angelia

I think you have a ) in the wrong place here - after .[day]. Should be:

result=MAXX(SUMMARIZE(relacje_data,relacje_data[Date].[day],"Amount",SUM(relacje_data[amount])),[Amount])

Regards

Julian