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.

     

     

     

     

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

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new table.

 

 

 

New Table =
FILTER (
    'Daily Price',
    'Daily Price'[Date] IN DISTINCT ( 'Monday Price'[Date] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Jihwan_Kim Thank you for your effort.

    I have tried this in Google Sheet and what I expected would be as below.

    But I am struggling to be done it in Power BI.

     

    Do you have any other suggestions?

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      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.

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thank you for you help, Jihwan_Kim.

    • 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.