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 guys,
I have table, include Page no / % Vlaue / Company name
I want a new column which should be calculated by Average of % Value column which are grouped by company and that company's page no.
Desired Column Name is "Avg of % Value" can be seen in the screen shot.
any help would be appriciated.
Solved! Go to Solution.
@acaryasin01 , Create a new columnin dax
=
averagex(filter(Table, [Company] = earlier([Company]) && [pageno] = earlier([pageno]) ) [% Value])
@acaryasin01 , Create a new columnin dax
=
averagex(filter(Table, [Company] = earlier([Company]) && [pageno] = earlier([pageno]) ) [% Value])
Sorry @amitchandak
I did mistake while applying yor dax formula,
Great thanks, It works.
Appreciated.
Hi @amitchandak
Thank you for your answer.
I applied this dax but it returned only one value to all rows?!
User | Count |
---|---|
76 | |
76 | |
41 | |
29 | |
24 |
User | Count |
---|---|
96 | |
91 | |
52 | |
46 | |
45 |