CODEWITHSUNDEEP
powerbidax
irrmat
irrmat

Reputation: 13

DAX - Max of each day in calculated column

I have data like in column Date and Amount and I am looking for DAX code to generate column MacOfDay (max of Amount for each day)

Example

Upvotes: 0

Views: 1822

Answers (1)

Foxan Ng
Foxan Ng

Reputation: 7151

You can try the following calculated column:

MaxOfDay = 
CALCULATE(
    MAX('Data'[Amount]),
    FILTER(
        'Data',
        'Data'[Date] = EARLIER('Data'[Date])
    )
)

Result:

result

Upvotes: 1

Related Questions