Forum Discussion
Solved
Historical line chart
Hello dear collaborators! I'd like to kindly ask for your help regarding the following: I have the below information and I would like to calculate the subtotals for A and B and then divide [(subtota...
You can achieve this by rolling up the date to year month format, then creating a measure to perform the calculation:
Hi,
You could create the Month-Num column in your table as below :
Month-Num = format(Sheet81[Date], "MM")And alsoValue = DIVIDE( sum(Sheet81[A]), sum(Sheet81[B] ))then use the created column in your visuals :
MahyarTF
Memorable Member
Memorable MemberHi,
You could create the Month-Num column in your table as below :
Month-Num = format(Sheet81[Date], "MM")
And also
Value = DIVIDE( sum(Sheet81[A]), sum(Sheet81[B] ))
then use the created column in your visuals :
Thank you for your alternative solution, MahyarTF! Much appreciatted!