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