Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, need help with two columns in a table (non unique values) that need to be counted on another table with unique values
Table A:
Serial Number | EoL Date 2 | EoV Date |
FCH2048FT8P | Not Published yet | Not Published yet |
FCH17018VD3 | 2024 | Prior 2024 |
WZP20350SSA | Not Published yet | Not Published yet |
FOC2133U12T | 2026 | 2025 |
WZP20350SYP | Not Published yet | Not Published yet |
FCH193093GN | Not Published yet | Not Published yet |
FOC2010S2B1 | 2028 | 2027 |
FCH1504DVMX | Prior 2024 | Prior 2024 |
FCW2018D098 | 2025 | 2025 |
FGL2019X04D | 2024 | 2024 |
FJC2405M4JN | 2027 | 2027 |
MXQ13800PF | Not Published yet | Not Published yet |
FCH1346AK4P | Prior 2024 | Prior 2024 |
FCW2336PQWG | 2027 | 2027 |
FCH1508A1PV | Prior 2024 | Prior 2024 |
FCW2132NBV0 | 2027 | 2027 |
WZP20350GCH | Not Published yet | Not Published yet |
FCH193093CB | Not Published yet | Not Published yet |
FCW2142NG24 | 2027 | 2027 |
FOC2016W1VK | 2029 | 2029 |
FCH2127DQZV | Not Published yet | Not Published yet |
FCW2336PRBL | 2027 | 2027 |
WZP20350GDP | Not Published yet | Not Published yet |
FCH2048FQ27 | Not Published yet | Not Published yet |
WZP20350T5M | Not Published yet | Not Published yet |
FCH192981ZJ | Not Published yet | Not Published yet |
FTX1923S4HT | 2024 | 2024 |
Table B:
Date | Count of EoL | Count of EoV |
Prior 2024 | ||
2024 | ||
2025 | ||
2026 | ||
2027 | ||
2028 | ||
2029 | ||
Not Published yet |
A single serial number sometimes have the same value as EoL and EoV but there are cases when those values are different for the same serial number as shown:
FCH17018VD3 | 2024 | Prior 2024 |
Been trying different ways but all the time the counts for both EoL and EoV always show the same value which is incorrect.
Solved! Go to Solution.
Hello @joseclaudio,
I created two measures Measure_EOL,Measure_EOV
Hello @joseclaudio,
I created two measures Measure_EOL,Measure_EOV
It worked like a charm!!! thanks I've been struggling with these a couple of weeks and now you saved me.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |