cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hwoehler Helper I
Helper I

get previous values per group

Hello everybody,
I would like to have the previous values ​​(see screenshot) displayed for the "ChangeWeek" column. So there should be a new column (see screenshot "new"), where the previous value per group (ISIN) is always displayed. It is important that it is a column, not a measure. I already got a solution in another post (https://community.powerbi.com/t5/Desktop/Get-weekly-values-and-previous-values/m-p/927847/highlight/...), but it's a measure there and not a column. Does anyone have a solution?

 

PBI File: https://we.tl/t-wYhdl5R56e
Best regards, hwoehler
prevValues.PNGscreenshot (Screenshot)

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: get previous values per group

Try , as new columns

Column = maxx(filter('Table','Table'[ISIN]=EARLIER('Table'[ISIN]) && not(ISBLANK('Table'[ChangeWeek])) && 'Table'[Date]<EARLIER('Table'[Date])),'Table'[Date])

Column 2 = if(ISBLANK('Table'[ChangeWeek]),BLANK(),maxx(FILTER('Table','Table'[ISIN]=EARLIER('Table'[ISIN]) && ('Table'[Date])=EARLIER('Table'[Column])),('Table'[ChangeWeek])))

 https://www.dropbox.com/s/kexca62xapy8j41/Filter2.pbix?dl=0





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


View solution in original post

5 REPLIES 5
Super User IV
Super User IV

Re: get previous values per group

So generally you are going to do this with something like EARLIER - See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395.... What is the measure calculation that fixed it? Should be very translatable to a column.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User IV
Super User IV

Re: get previous values per group

@hwoehler , can ypu let us know the logic of last column. Not very clear from the example





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


Highlighted
hwoehler Helper I
Helper I

Re: get previous values per group

Hi @amitchandak ,

you're right. The screenshot is misleading. This screenshot should be better:
prevValues2.PNGdesired column "new"The column "new" consists of (always) the previous value. (based on column "ChangeWeek".
Best regards, hwoehler

Super User IV
Super User IV

Re: get previous values per group

Try , as new columns

Column = maxx(filter('Table','Table'[ISIN]=EARLIER('Table'[ISIN]) && not(ISBLANK('Table'[ChangeWeek])) && 'Table'[Date]<EARLIER('Table'[Date])),'Table'[Date])

Column 2 = if(ISBLANK('Table'[ChangeWeek]),BLANK(),maxx(FILTER('Table','Table'[ISIN]=EARLIER('Table'[ISIN]) && ('Table'[Date])=EARLIER('Table'[Column])),('Table'[ChangeWeek])))

 https://www.dropbox.com/s/kexca62xapy8j41/Filter2.pbix?dl=0





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


View solution in original post

Super User IV
Super User IV

Re: get previous values per group

Yep, EARLIER.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors