Having two fact tables that has one-to-many relationship with Calendar table.One table contains data with daily price (category would not be considered) and other table with the Monday date price data. Monday Price TableDatePrice9/5/20221009/12/20221039/19/20221079/26/202210510/3/202210210/10/2022108 Daily Price TableDateCategoryPrice9/5/2022Vege609/6/2022Fruit679/7/2022Vege789/8/2022Fruit679/9/2022Vege669/10/2022Fruit809/11/2022Vege509/12/2022Fruit749/13/2022Fruit589/14/2022Vege589/15/2022Vege639/16/2022Vege529/17/2022Fruit719/18/2022Fruit639/19/2022Vege789/20/2022Fruit719/21/2022Fruit789/22/2022Vege649/23/2022Vege529/24/2022Fruit639/25/2022Vege759/26/2022Fruit519/27/2022Vege599/28/2022Fruit569/29/2022Fruit769/30/2022Vege5010/1/2022Vege7610/2/2022Vege6010/3/2022Fruit5510/4/2022Fruit5910/5/2022Vege7910/6/2022Fruit6010/7/2022Vege7410/8/2022Fruit76 I would like to make comparison of this two tables by taking the value that have only matched with Monday Price Table. Can I get some help that how to write DAX that only return data from Daily Price Table that is matching Date from Monday Price Table?And what about if we only have the random Date data instead of every Monday data?

Hi, Thank you for your feedback. Please check the below picture and the attached file. It is for creating a new table.

Anonymous

Not applicable

3 years ago

Solved

Compare only Matched Date Value

Having two fact tables that has one-to-many relationship with Calendar table.
One table contains data with daily price (category would not be considered) and other table with the Monday date price data.

Monday Price Table

Date	Price
9/5/2022	100
9/12/2022	103
9/19/2022	107
9/26/2022	105
10/3/2022	102
10/10/2022	108

Daily Price Table

Date	Category	Price
9/5/2022	Vege	60
9/6/2022	Fruit	67
9/7/2022	Vege	78
9/8/2022	Fruit	67
9/9/2022	Vege	66
9/10/2022	Fruit	80
9/11/2022	Vege	50
9/12/2022	Fruit	74
9/13/2022	Fruit	58
9/14/2022	Vege	58
9/15/2022	Vege	63
9/16/2022	Vege	52
9/17/2022	Fruit	71
9/18/2022	Fruit	63
9/19/2022	Vege	78
9/20/2022	Fruit	71
9/21/2022	Fruit	78
9/22/2022	Vege	64
9/23/2022	Vege	52
9/24/2022	Fruit	63
9/25/2022	Vege	75
9/26/2022	Fruit	51
9/27/2022	Vege	59
9/28/2022	Fruit	56
9/29/2022	Fruit	76
9/30/2022	Vege	50
10/1/2022	Vege	76
10/2/2022	Vege	60
10/3/2022	Fruit	55
10/4/2022	Fruit	59
10/5/2022	Vege	79
10/6/2022	Fruit	60
10/7/2022	Vege	74
10/8/2022	Fruit	76

I would like to make comparison of this two tables by taking the value that have only matched with Monday Price Table.

Can I get some help that how to write DAX that only return data from Daily Price Table that is matching Date from Monday Price Table?
And what about if we only have the random Date data instead of every Monday data?

Need Help

Tips and Tricks

Jihwan_Kim
3 years ago
Hi,

Thank you for your feedback.

Please check the below picture and the attached file.

It is for creating a new table.

yannaing.pbix25 KB