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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Calculated column with filter

Capture12.PNG

 

Hi,

 

Really simple question but seems to be difficult to solve.

 

The idea is to flag price changes of a list of articles. I'm trying to make a calculated column where only price changes will be visible. Can someone help me get this figured out?

 

 
 
 

 

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

Your question is not clear.  There is already a Price change column there.  What is the purpose of that column?  How did you arrive at the numbers in that column?  What exact result are you expecting?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Capture13.PNG

 

Very sorry for my unclear explanation.

 

Above table i made in excel to explain what i'm looking for:

Every day prices are updated of certain artikels. We would like to know when a price is changing. So, above figure shows that on the 4th of Jan there was a price change of artikel C. Basically i would like to know what the price change is and when the change has been uploaded.

 

Hope this is more clear.

Hi,

Share your data such that be pasted in an Excel file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.