Forum Discussion
Getting the latest value per date and using intervals
Hi,
I have the following sample data:
| quarter | parameter | date | value |
| 1T | IND03 | 31/01/2025 | 6 |
| 1T | IND03 | 28/02/2025 | 4 |
| 1T | IND03 | 31/03/2025 | 3 |
| 2T | IND03 | 30/04/2025 | 2 |
| 2T | IND03 | 31/05/2025 | 6 |
| 1T | IND01 | 31/01/2025 | 2 |
| 1T | IND01 | 28/02/2025 | 3 |
| 1T | IND01 | 31/03/2025 | 4 |
| 2T | IND01 | 30/04/2025 | 4 |
| 2T | IND01 | 31/05/2025 | 7 |
I also have the following data with goals for each parameter per quarter:
| parameter | quarter | goal1 | goal2 | goal3 | goal4 |
| IND01 | 1T | 0 | 1 | 2 | 5 |
| IND01 | 2T | 0 | 1 | 2 | 5 |
How can i create a measure that returns the value of the latest parameter for each quarter (the most recent date) and determines which goal its surpassing? I have also connected a relationship between the two tabels, by combining quarter and parameter in a column.
Thanks.
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
6 Replies
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
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
Hi qmestu ,
Thank you for contacting the Fabric Community. I have gone through FBergamaschi , response and found that it meets your requirements and expectations. Please review her reply in detail, as well as the attached PBIX file for your reference.
Thanks to FBergamaschi , for providing a clear and helpful solution.
Best regards,
Community Support Team _Yugandhar.Hi qmestu ,
Have you been able to review the response from FBergamaschi . Does it meet your needs, or are there any changes you would like us to make? Let us know.
Thank You.
Hi qmestu ,
If your issue is resolved, that’s good to hear. But if you're still facing any difficulties or running into new challenges, feel free to let me know.
Thank You.
Hi qmestu ,
Could you let me know if your issue is resolved, or if you need any additional details.
Thanks.
