Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey All,
I am trying to using EVALUATE (or anything better) table function in DAX and it keeps giving me a error (red line under EVALUATE).
I am trying to achieve the below:
TABLE 1 WITH ALL ID'S -
TABLE 1 ID | COLUMN1 | COLUMN2 | COLUMN3 | COLUMN4 | COLUMN5 |
1 | X | AB | TT | YY | IYT |
2 | Y | BC | TG | YYY | RTS |
3 | Z | CD | THH | QQQ | HHD |
TABLE 2 WITH ONLY 1 MATCHING ID
TABLE 2 ID | DESCRIPTION | VALIDITY | TENURE |
1 | THIS IS ON SALE | YES | 12 MONTHS |
23232 | THIS IS OUT OF STOCK | NO | 2 MONTHS |
112341 | DISCOUNTED | YES | 3 MONTHS
|
RESULTING TABLE THAT IS NEEDED
TABLE 1 ID | DESCRIPTION | VALIDITY | TENURE |
1 | THIS IS ON SALE | YES | 12 MONTHS |
2 | NULL | NULL | NULL |
3 | NULL | NULL | NULL |
I know the above is easily availbale with Merge and then do a LEFT JOIN in it in Power Query, but my Table 2 is a DAX Generated Table which does not show up on the Power Query side for me to MERGE with Table 1.
Thank You
Hi @nirvana_moksh,
Create a relationship between both tables then add the TABLE1 ID to your table visual and the Other columns from table 2.
then filter out all blanks from TABLE1 ID
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsSo when I do that then the resulting Table only shows values that are also present in Table 2 based on the ID, I have the relationship set already. I just want all ID's from Table 1 and corresponding values from Table 2 and nulls for where there is no value present in Table 2. I did play with EVALUATE and GENERATEALL but that did not get me where I wanted this to be.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |