Getting the latest value per date and using intervals

[qmestu]

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.

[V-yubandi-msft]

Hi @qmestu ,

Could you let me know if your issue is resolved, or if you need any additional details.

Thanks.

[V-yubandi-msft]

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.

[V-yubandi-msft]

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.

[V-yubandi-msft]

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.

[FBergamaschi · Accepted solution]

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

[FBergamaschi]

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