Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Script to add column based on historical data


I've been trying to add automatic column with py script, but without a success. So the idea is to lets say i have a table like below:



Default TableDefault Table



And the idea is to create a additional column which tells us a current situation of A or B value over time, so basically something like this: ( let's say that 7-th month data is updated)


Table with new columnTable with new column




Did anyone took similar approach to something like above? Looking for a suggestions & approach ideas or some solutions to problem above. A & B columns could also be like A (as value) and B as value category.

Thanks in advance!!

Community Support
Community Support

Super User
Super User

You could do something like this with a measure incorporating a bunch of if/then logic specifying what you want to say in any conceivable situation but that seems pretty painful to write and not nearly as useful as showing a visual instead.

Obviously, but in my case there is a need to have tooltip/comments in addition to graph. My idea was to loop through dates and output value progression over time but as mentioned above - ended up without success.
Nested ifs are painful - i agree, but i consider it as last resort.
Thanks for your reply!

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors