Forum Discussion
Diptarup
5 years agoHelper II
Dax Calculation
I am new to the PowerBi and would require assistance to solve a problem. I want to get the value of the product A & B based on the second highest year. As shown in the below table ,I want to have a f...
Diptarup
5 years agoHelper II
Can you please share the calculation for the col "Column" as the pbix file that you have acttcahed i am unable to open it due to some issue
v-henryk-mstf
5 years agoCommunity Support
Hi Diptarup ,
The calculated column is below:
Column = IF('Table'[Product]="A",1,2)
Best regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.