cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

 Date Planned Changed 01/09/2021 8400 NO 02/09/2021 8400 NO 03/09/2021 8500 YES 04/09/2021 8500 NO 05/09/2021 8400 YES 06/09/2021 8400 NO 07/09/2021 8400 NO 08/09/2021 8400 NO

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

1 ACCEPTED SOLUTION
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())``

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

2 REPLIES 2
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())``

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

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

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors