cancel
Showing results for
Did you mean:
Occasional Visitor

## dsum in power bi?!

hi,

i have a table in DW that is updated every month.

how can I use DAX for summarizing "product a" for the most updated date?

 date product a product b 01/01/2018 69 500 01/01/2018 1669 5221 01/01/2018 0 128 01/01/2018 0 0 01/02/2018 0 129 01/02/2018 69 500 01/02/2018 1668 5220 01/02/2018 0 0 01/03/2018 1666 5222 01/03/2018 0 127 01/03/2018 69 497 01/03/2018 0 0 01/04/2018 1661 5221 01/04/2018 69 497 01/04/2018 0 127 01/04/2018 0 0 01/05/2018 1661 5221 01/05/2018 69 497 01/05/2018 0 127 01/05/2018 0 0
1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: dsum in power bi?!

I think this calculated measure will work for the data as you present it.  I have attached a PBIX file that shows this and also a measure that works with Product B.  However I recommend you pivot your data around so that Products are in rows and not columns.

```Most Updated Product A =
MAXX(
FILTER(
'Table1',
'Table1'[product a]=MAX('Table1'[product a])
),
'Table1'[date]
)```

Proud to be a Datanaut!

Microsoft

## Re: dsum in power bi?!

I think this calculated measure will work for the data as you present it.  I have attached a PBIX file that shows this and also a measure that works with Product B.  However I recommend you pivot your data around so that Products are in rows and not columns.

```Most Updated Product A =
MAXX(
FILTER(
'Table1',
'Table1'[product a]=MAX('Table1'[product a])
),
'Table1'[date]
)```

Proud to be a Datanaut!

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!