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 team
please help me t reslove this problem
I want to generate a new column in each line there is the product of cellulles selected in green
Solved! Go to Solution.
Hi @anassel,
You can create a index column:
index = CALCULATE(COUNT(Table1[Column1]),FILTER('Table1','Table1'[Column1]<=EARLIER(Table1[Column1])))
Then create a calculated column below:
Column = CALCULATE(SUM(Table1[Column1]),FILTER('Table1','Table1'[index]>EARLIER(Table1[index])))
+ CALCULATE(SUM(Table1[Column2]),FILTER('Table1','Table1'[index]<EARLIER(Table1[index])))
+ Table1[Column3]
Best Regards,
Qiuyun Yu
Hi @anassel,
You can create a index column:
index = CALCULATE(COUNT(Table1[Column1]),FILTER('Table1','Table1'[Column1]<=EARLIER(Table1[Column1])))
Then create a calculated column below:
Column = CALCULATE(SUM(Table1[Column1]),FILTER('Table1','Table1'[index]>EARLIER(Table1[index])))
+ CALCULATE(SUM(Table1[Column2]),FILTER('Table1','Table1'[index]<EARLIER(Table1[index])))
+ Table1[Column3]
Best Regards,
Qiuyun Yu
thank you for your solution .
but I want instead of the SUM I do the product .
Thanx 😉
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |