Forum Discussion

HabibAdil's avatar
HabibAdil
Icon for Helper IV rankHelper IV
6 years ago
Solved

Creating Matrix with Data from Unrelated Tables

Hi, Can someone please tell me how can I replicate this matrix in power bi (image 1). The Quote and Sales data are in different tables with different dates (quote received date, sales order date). I...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi HabibAdil ,

     

    Not sure if i get your point, but you can use SELECTEDVALUE() function if there's no relationship between two tables.

    Example:

    calculate(sum(column1),filter(table,table[date]=selectedvalue(calendar[date])))

    https://docs.microsoft.com/en-us/dax/selectedvalue-function 

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HabibAdil's avatar
HabibAdil
Icon for Helper IV rankHelper IV
6 years ago

Hi Anonymous 

 

Thanks for your help. Unfortunatley, this topic is not what I want. I might have to create a matrix for each initiative in excel sheet and put them on top of each other.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi HabibAdil ,

     

    Not sure if i get your point, but you can use SELECTEDVALUE() function if there's no relationship between two tables.

    Example:

    calculate(sum(column1),filter(table,table[date]=selectedvalue(calendar[date])))

    https://docs.microsoft.com/en-us/dax/selectedvalue-function 

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.