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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Spudduk
Frequent Visitor

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
v-rongtiep-msft
Community Support
Community Support

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
v-rongtiep-msft
Community Support
Community Support

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")

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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