Display Minimum Historical Rate for each product against today's rate

[samihuq]

Hi There,

I have following dataset in "Data" Table:

Date	Product	Rate
01-Jan-16	A	15
02-Jan-16	A	13
03-Jan-16	A	9
04-Jan-16	A	13
05-Jan-16	A	13
01-Jan-16	B	15
02-Jan-16	B	9
03-Jan-16	B	14
04-Jan-16	B	9
05-Jan-16	B	6
01-Jan-16	C	6
02-Jan-16	C	14
03-Jan-16	C	10
04-Jan-16	C	6
05-Jan-16	C	8

Is it possible to create a report that will display the Minimum Rate for each Product for all given date? Result Table Shown bellow:

Product	A
Date	Rate	Min of Rate
01-Jan-16	15.00	9.00
02-Jan-16	13.00	9.00
03-Jan-16	9.00	9.00
04-Jan-16	13.00	9.00
05-Jan-16	13.00	9.00

and 

Date	05-Jan-16
Product	Todays Rate	Min Rate Historically
A	13.00	9.00
B	6.00	6.00
C	8.00	6.00

Thanks for your help.

Regards,

---

Sami

[Baskar · Accepted solution]

Cool Dude,

Try this, look the image attached here

Let me know if it is not helping u  

[samihuq]

Thanks Baskar for your superfast responds, it solved my problem 🙂

Cheers,
Sami

[Baskar]

Cool , Always welcome dude. lets we rockzzz with Power BI and DAX.