Forum Discussion
Using the First Value Of a Group
Hello, Below is what I am trying to accomplish. Use the cost for the first vendor in the grouping, where the "As Of" date selected falls w/in the Effective/Expiration range. Grouping is by Catego...
Hi ,
Please apply it to visual level filter not put it into table visual.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I did have the visual filter set to 1 for Measure 2, but unfortunately it still doesn't work when the as of date is changed from 2/1/2022 to 1/12/2022. The cost for cost code 1234 should change from $250 to $150 instead.