Forum Discussion

HabibAdil's avatar
HabibAdil
Helper 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
Helper 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.