Hi! I'm working on data for multiple years and I want to return the month when the target is reached. I am for the most part working with measures so referencing them in the MINX formula is tricky. What I'm thinking is to calculate a table or summarize the result of the ratios (computed with the MINS measure) by year and get the minimum ratio per year, and return the corresponding date but I don't know how to do that Here is the file for anyone who wants to help. https://drive.google.com/file/d/1PnaHIDRKaQ_musoJU8iEwYhEbBLh-roi/view?usp=sharing
Based on test, I think the issue related to your target measure, it not support auto drill to next hierarchy level to get the specific. If you not add month as row label, it only calculate on year level.
Community Support Team _ Xiaoxin Sheng If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For learning resources/Release notes, please visit: | |