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.
Hi
I am strugeling with the following,
I have two tables.
Table A - a claculated table (so cant use power query) - get the number of item produced in each step by date
Table B- is a key table that indicate what and how many test ate done on each step.
I want to generate a table that will show how many test per test type are preformed every day.
here are the diffrent tables. I could easily creat the result with power query, but since table A is a claculated table in my scenario, i need a dax based solution.
Thank you
for all your help
Solved! Go to Solution.
Dear all
I was able to find a solution.
hope it helps someone
step 1 :
creat a new table based on summerization of the Table A mentioned above
Step 2 make a relationship between new table and table B based on the "Step"
for each test a calculated column
# of test =
Dear all
I was able to find a solution.
hope it helps someone
step 1 :
creat a new table based on summerization of the Table A mentioned above
Step 2 make a relationship between new table and table B based on the "Step"
for each test a calculated column
# of test =
@Eyal , if Table A is Table; you have as the source, I think you should better reconsider the source format. If not please share the sample source data for A and B in text format
I am not sure I follow.
Table A in my real life scenario is a claculated table.
It is generated by :
Table A | ||||
Step | # of items | date | ||
step1 | 1 | 01/01/2021 | ||
step1 | 3 | 02/01/2021 | ||
step1 | 5 | 05/01/2021 | ||
step2 | 4 | 01/01/2021 | ||
step2 | 1 | 02/01/2021 | ||
step2 | 1 | 03/01/2021 | ||
step2 | 2 | 05/01/2021 | ||
step3 | 1 | 02/01/2021 | ||
step3 | 1 | 04/01/2021 | ||
step4 | 2 | 01/01/2021 | ||
step4 | 2 | 02/01/2021 | ||
step4 | 3 | 04/01/2021 | ||
Table B | ||||
Step | Test1 | Test2 | Test3 | Test4 |
Step1 | 1 | 3 | 1 | |
Step2 | 1 | |||
Step3 | 1 | 3 | 1 | |
Step4 | 1 | 1 |
Thank you
Eyal
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 |
---|---|
99 | |
97 | |
85 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |