Forum Discussion

Anonymous's avatar
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 d...
Need Help
Tips and Tricks
  • Jihwan_Kim's avatar
    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.

     

     

     

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
3 years ago

Anonymous You can create new table by writing this DAX code:

Table = SUMMARIZE(FILTER(DailyPriceTable,DailyPriceTable[Date]=RELATED(MondayPriceTable[Date])),DailyPriceTable[Date],DailyPriceTable[Category],"Daily Price", SUM(MondayPriceTable[Price]),"Monday Price",SUM(MondayPriceTable[Price]))

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Tahreem24 Thank you for your effort.
The RELATED() doesn't work in mine.