Forum Discussion
Anonymous
3 years agoNot applicable
Using column header as values for calculation
Hi Experts, I have a table as below in my Power BI: 2022 2023 2024 Next_Order_Year 0 1 2 2025 0 1 ...
ryan_mayu
3 years agoSuper User
Anonymous
here is a workaround for you.
1. create a reference table , user hearder as first row , transpose table and remove text value.
2. create a column in original table
Column = CALCULATE(COUNTROWS('Table (2)'),FILTER('Table (2)','Table (2)'[Column1]<'Table'[nextorderyear]))
pls see the attachment below