How to reference a 1st virtual table column in 2nd virtual table column in dax table

[Muhammad_Ahsan]

Dear All,

 

Hope you are doing well.

I am creating a virtual table , in which i want to reference dax calculated column 1 in another dax expression in second dax calculated column. 
for e.g.

ALL_STUDENTS_LASTDATE_PERFORMANCE_v3 =

 CALCULATETABLE(

     DISTINCT(

         SELECTCOLUMNS(ALL_CLASSES_FOR_DAILY_REPORT, "Student_Name", ALL_CLASSES_FOR_DAILY_REPORT[STUDENT NAME],

         "Report_Date", MAX(ALL_CLASSES_FOR_DAILY_REPORT[Timestamp].[Date]),

         "Department", ALL_CLASSES_FOR_DAILY_REPORT[Department],"Current_Stage", RELATED('STUDENT MASTER'[Current Stage]) ,

         "Duration_From_Joining",

DATEDIFF((RELATED('STUDENT MASTER'[Joining Date])), max(ALL_CLASSES_FOR_DAILY_REPORT[Timestamp]), MONTH), "Hifz_Stage", 1 ,

    "Hifz_Stage_Reference",

 [Hifz_Stage]

(now this is first column [hifz_stage] defined above, now i want to use this column [hifz_stage] in second column as well ) how to achieve this ?

))  

   

 
I tried and it is giving following error.

[Anonymous · Accepted solution]

Hi @Muhammad_Ahsan 

If you want to use the columns in the first virtual table in the second virtual table, you need to add some filter conditions, such as the same ID column in Table 1 and Table 2, and then go to Table 1 to find the value in the column, you can refer to the example.

I create a calculated table, the virtual table a is created, a flag column is added to a, and if the value > 6, it is assigned 1, otherwise it is 0. Then in the current table, reference the flag column in the virtual table to find the relevant value, and in the flag column that returns the value, you can use the Maxx() and filter() functions to combine.

Table 2 = var a=ADDCOLUMNS(GENERATESERIES(1,10,1),"Flag",IF([Value]>6,1,0))
 return ADDCOLUMNS({5,8,10},"Flags",MAXX(FILTER(a,[Value]=EARLIER([Value])),[Flag]))

Output

So for example, if you want to reference [Hifz_Stage] in the v1 table in the v2 table you are creating, you need to go to the v1 table to find it and then reference the column.

Best Regards!

Yolo Zhu

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