Forum Discussion
Getting the latest value per date and using intervals
Hi again,
I completed the thing, reading better it was clear, apologies for not understanding
Here is my result, with your sample data
Here is the file pbix:
https://drive.google.com/drive/folders/1beZLGE0rxZOeLOUVVF2DZ5l43ZBpxfCH?usp=sharing
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hello qmestu
I am working on this bu tthe problem is that for each quarter there are mutiple paramters that satisfy your condition
(ex in 1T, IND03 and IND01 are both on march 31 2025) and they can have different values, which value should we consider in this case?
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI