Hi all!
I want to build a Pivot Table Card with columns being each month from start to current date , rows as IDs and each value to be a constant number. However, in the dataset there's one row per ID showing start date, its status and the constant number (ID-1 ; 01/01/2016; active; 150). So, when building the card the constant value appears only in the month for start_date as expected, but I'd like to see this value for each month where its status were active.
I'm thinking in creating a dataflow with an extra date column, that duplicates each ID's information from its start date til today if its status is active, but I'd love to hear if there's an easier way to accomplish this!
| ID | Jan-21 | Feb-21 | ... | Mar-22 |
1 | 150 | 150 |.... | 150 |
Thanks!