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.
Hi,
I am using the below method:
Solved! Go to Solution.
It would be easier to tackle your case having a mocking example of your dataset.
Please check the attached file - maybe it is what you need.
Best Regards,
Alexander
Hi @lafakios,
You should leave only unique values first with the help of VALUES or DISTINCT and then concatenate them.
Like that:
In plain text:
AllDates = CONCATENATEX ( CALCULATETABLE ( VALUES ( Table1[YYYY-MM] ), Table1[Date] < DATE ( 2014, 1, 1 ) ), Table1[YYYY-MM], ", " )
Best Regards,
Alexander
The above suggestion cannot unfortunately be used in this case.
The item is a kind of key (which is not unique at Table1 but is unique at Table2).
The item is found in Table 1 several times with a different value of YYYY-MM.
In Table2 which has only the distinct values of the items, for each item I would like to have in an column a summary of all YYYY-MM values that are present at the various entries of that item in Table1.
Please note that the YYYY-MM values are handled as text in both tables.
That's why I am using the expression: Table1[Item] = Table2[Item]
It would be easier to tackle your case having a mocking example of your dataset.
Please check the attached file - maybe it is what you need.
Best Regards,
Alexander
Hi,
This did deliver the wanted result, thank you a lot for your help!
I am also providing below the suggested formula of the solution:
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |