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...
I tried your suggestion, thank you!! It is close but doesn't work when the date selected is changed to include the older effective/expiration date range. The older date range cost is included in the first screen print, but see the second screen print and what happens when I add Measure 2 to the grid.
Before adding Measure 2 to the grid:
After adding Measure 2 to the grid:
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.