topic Re: Script to add column based on historical data in Developer

Script to add column based on historical data

hejszyszky — Wed, 17 Nov 2021 19:53:13 GMT

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 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 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!!

Re: Script to add column based on historical data

AlexisOlson — Wed, 17 Nov 2021 20:44:30 GMT

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.

Re: Script to add column based on historical data

hejszyszky — Wed, 17 Nov 2021 21:13:58 GMT

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!

Re: Script to add column based on historical data

V-lianl-msft — Tue, 23 Nov 2021 05:15:56 GMT

See if dynamic commentary in Power BI can meet your needs:

https://zebrabi.com/dynamic-commentary-power-bi/

https://blog.enterprisedna.co/adding-commentary-to-your-reports-in-a-dynamic-way/