Forum Discussion

murphm6's avatar
murphm6
Helper II
4 years ago

ISINSCOPE with date column in matrix

Hey everyone,   I'm running into an issue with my Matrix visual in a PowerBI report. I have 3 levels of hierarchy in the matrix:   1)Product Name (ends in C-5000) 2)Product Code (ends in Bulk) ...
Need Help
ddpl's avatar
ddpl
Solution Sage
4 years ago

murphm6 

Hey, Create a measure and put it in your matrix,

 

Expired Date You Need = IF(HASONEVALUE('Table'[Exp Date]), MAX('Table'[Exp Date]), BLANK())