Forum Discussion

mshamsiev's avatar
mshamsiev
Icon for Helper I rankHelper I
9 years ago
Solved

Cross Data Filtering

Hi everyone!   I have three separate data sources (active, closed, opened) jobs. Each one has a column which lists the Task Type (ie. incident, request etc).    What I'm trying to do is create a ...
  • mshamsiev's avatar
    mshamsiev
    9 years ago

    Hi Phil_Seamark and Anonymous,

     

    Thanks again for the help. I ended up recreating the initial data table to overcome the issue. 

     

    See you guys around the forums! 

     

    -Mike 

mshamsiev's avatar
mshamsiev
Icon for Helper I rankHelper I
9 years ago

Hi Phil_Seamark,

 

Thanks for the reply! All three datasources are separate tables. They all have columns which include 'assignment group' 'task type' and 'date'. So I created three further tables containing each of those variables and matched them. Do I need to combine them?

 

Much appreciated.

 

-Mike  

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi mshamsiev

 

You don't need to combine them, but if they are as similar as it sounds like, it will make filtering and other measures easier if they are in the same table.  

 

You can do this in DAX using a UNION function, but I'd recommend you do it in the Query Editor using the Append Queries function on the Home tab.