Forum Discussion
Solved
2 dimensions lookup on the same data table, I need help please.
The dashboard: https://shorturl.at/ZgEy3 In my data. batch number for product 1 are Batch 1-X, same as for product 2,3,4. I have fact data table fData with 3 categories: - From warehouse: WH1 & ...
Hi again,
I spent a bit of time on the first part and could not figure out a way to make it work with the limitations you have (not modifying the dataset, measures only).
I would suggest that you can use a slicer on the page for Product Batch, and instead of clicking on rows in the Expired table, the user would have to find a row, check the batch number, and select it in the slicer. With the sample dataset from before:
Hope this helps!
Thank you very much, that's not what I need at the moment because users will lookup at the Product number instead of Batch number. But thanks a lot for you help!