Forum Discussion

Birinder's avatar
Birinder
Helper III
4 years ago
Solved

How to create a dummy table ?

Hi there, My query is very simple. Suppose, We have 3 different data tables, which are related to each other. Now I want to show each column from a different data source in a new dummy table. L...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Birinder ,

     

    Based on my test, we could not use DAX to create calculated column and calculated table when using Live connetion mode:

     

    If the original relationship is as below:

    You could directly drag fields to Table visual:

     

     

    Or please create a measure instead:

     

    Measure = CALCULATE(SUM('TABLE 3'[Price]),FILTER('TABLE 3',[Date]=MAX('TABLE 2'[Date])))

     

     

     

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Birinder ,

 

Based on my test, we could not use DAX to create calculated column and calculated table when using Live connetion mode:

 

If the original relationship is as below:

You could directly drag fields to Table visual:

 

 

Or please create a measure instead:

 

Measure = CALCULATE(SUM('TABLE 3'[Price]),FILTER('TABLE 3',[Date]=MAX('TABLE 2'[Date])))

 

 

 

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