Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

Reply
Spudduk
Helper I
Helper I

Measure to show the date when a Value has changed

I have a dataset, simplified version below, what I have been asked to provide a tile which highlights when Data has been changed  and also the TO and FROM values ?

 

Example on data below would show 

03/09/2021 Changed from 8400 to 8500

05/09/2021 Changed from 8500 to 8400

 

DatePlannedChanged
01/09/20218400NO
02/09/20218400NO
03/09/20218500YES
04/09/20218500NO
05/09/20218400YES
06/09/20218400NO
07/09/20218400NO
08/09/20218400NO

 

Is this possible and any ideas or suggustions would be appreciated?

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Spudduk ,

 

Create two measures.

 

previous = CALCULATE(SUM('Table'[Planned]),FILTER(ALL('Table'),'Table'[Date] =  EDATE(SELECTEDVALUE('Table'[Date]),-1)))

 

tile = IF(SELECTEDVALUE('Table'[Changed])="YES",MAX('Table'[Date])&" Change From " & [previous] & " To " & SELECTEDVALUE('Table'[Planned]),BLANK())

 

Capture.PNG

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Best Regards

Community Support Team _ Polly

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @Spudduk ,

 

Create two measures.

 

previous = CALCULATE(SUM('Table'[Planned]),FILTER(ALL('Table'),'Table'[Date] =  EDATE(SELECTEDVALUE('Table'[Date]),-1)))

 

tile = IF(SELECTEDVALUE('Table'[Changed])="YES",MAX('Table'[Date])&" Change From " & [previous] & " To " & SELECTEDVALUE('Table'[Planned]),BLANK())

 

Capture.PNG

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Best Regards

Community Support Team _ Polly

 

amitchandak
Super User
Super User

@Spudduk , Try a new column like

 

new column =
var _max = maxx(filter(Table, [Date] <earlier([date])),[Date])
return
if(maxx(filter(Table, [Date] <earlier([date])),[planned]) <> [Planned] , "No", "Yes")

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.