Power BI Calculated Column to only show if data has changed from the previous date

[Brady-Linnebur]

Hello,

I have been making this calculated column and running into some issues. I am attaching the excel file replica of the data I am trying to use. I need a calculated column to only show data if there was a change from the previous week. Example would be say an item is there for 5 weeks. It starts off at 24, then is 24 for two more weeks, then on the 4th week it goes to 30. Then the 5th week is also 30. I need it to read out 24, blank, blank, 30, blank. If you need more details let me know and I will respond as soon as I can.

[v-tianyich-msft · Accepted solution]

Hi @Brady-Linnebur ,

I made simple samples and you can check the results below:

Measure = var _t = ADDCOLUMNS('Table',"A",MAXX(FILTER(ALL('Table'),[Item #]=EARLIER([Item #])&&[Week starting]=EARLIER('Table'[Week starting])-7),[Units]))
RETURN IF(MAXX(_t,[A])=MAX('Table'[Units]),BLANK(),MAX('Table'[Units]))

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[Brady-Linnebur]

I couldn't find out how to upload the excel so here is a screenshot of it.