Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Looking for assistance!
We are trying to use the difference between; TestID 2, V1 and TestID 1 V1 in Table1, as the Z value for V1 in Table2.
In Table1 I have some data from a test.
We have created measures to return the differnce between TestID 2, V1 and TestID 1 V1 as well as TestID 2, V2 and TestID 1 V2, they return the below.
Measure
Solved! Go to Solution.
Hi @Anonymous ,
According to your description, my understanding is that you are going to put the difference of V1 (Last one - Top one) to the set V1-Z.
Assume that we have the following two tables:
Then we can create a measure like below:
Z = IF ( MIN ( Table2[VAR] ) = "V1", CALCULATE ( MIN ( Table1[V1] ), TOPN ( 1, Table1, Table1[TestID], DESC ) ) - CALCULATE ( MIN ( Table1[V1] ), TOPN ( 1, Table1, Table1[TestID], ASC ) ), CALCULATE ( MIN ( Table1[V2] ), TOPN ( 1, Table1, Table1[TestID], DESC ) ) - CALCULATE ( MIN ( Table1[V2] ), TOPN ( 1, Table1, Table1[TestID], ASC ) ) )
The result will like below:
Best Regards,
Teige
Hi @Anonymous ,
According to your description, my understanding is that you are going to put the difference of V1 (Last one - Top one) to the set V1-Z.
Assume that we have the following two tables:
Then we can create a measure like below:
Z = IF ( MIN ( Table2[VAR] ) = "V1", CALCULATE ( MIN ( Table1[V1] ), TOPN ( 1, Table1, Table1[TestID], DESC ) ) - CALCULATE ( MIN ( Table1[V1] ), TOPN ( 1, Table1, Table1[TestID], ASC ) ), CALCULATE ( MIN ( Table1[V2] ), TOPN ( 1, Table1, Table1[TestID], DESC ) ) - CALCULATE ( MIN ( Table1[V2] ), TOPN ( 1, Table1, Table1[TestID], ASC ) ) )
The result will like below:
Best Regards,
Teige