Forum Discussion
How to create a dummy table ?
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.
Birinder , One way is to join tables 1 and 2 on product and then join and 2 and 3 date and put the required columns in visual
Or you can use natural left join https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
I guess you still dont get it. No worries. I will explain as best as I can.
The data is live connected.It is live, so nothing appears in power query. I know I can join on table and product. But for that I need Power query. I don't want to use power query.
What to write here. Like we do function, "SELECTCOLUMNS" and input parameters to get a new desired table.
I want something like this.
Is this possible ?
Birinder , if you are able to create DAX table then NATURALLEFTOUTERJOIN and NATURALINNERJOIN are DAX functions. for which I shared link https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Sorry for confusion