Hi @Shaurya ,
Thanks for the help.
I am trying to understand your measure. Did you have time to take a look at my Power BI one drive?
Product = IF('Table'[Period]="AVG 3", 'Table'[1-Ult],0) * IF('Table'[Period]="AVG 6", 'Table'[1-Ult],0)
1) Are you multiplying the AVG 3 * AVG 6? Because my end goal is to get the product of the whole Average 3 row, like the picture, I attached below:
2) Table[period] and Table[1-Ult] - Will the period be the date I am using? but what is Table[1-Ult]?
I am trying to understand a little bit better what you did.
Thanks again for the help.