Forum Discussion
hdavidson
Helper I
Helper IHelp with a measure in DAX.
This one is a little tricky & has me pulling my hair out. TestMeasure = var currentMonth = SELECTEDVALUE(MyTable[Month]) var currentYear = SELECTEDVALUE(MyTable[ValYear]) var currentQuarter = ...
vanessafvg
Community Champion
Community Championcan i ask what your objective is, what are you trying to do?
hdavidsonHelper I
Helper Ivanessafvg ,pls see below what I am trying to do :
I cannot share my dataset but lemme show you some sample calcs -
so as we see below, my A4 cell will be A5 (lets say there is no value) so it will be (zero divided by Col1 = 0) + Col7 = Col7
Now, the starting point for calculating the value in A3 cell will be the value in A4 (i.e. the numerator will be the answer of the calculation in cell A4) and so on i.e for A2 the starting point will be the value in the A3 cell (i.e. result of A4 /Table Col1 + Table Col7 )
Hope this helps..
A1 A2 A3 A4
| =A2/ Table Col1 + Table Col7 | =A3 / Table Col1 + Table Col7 | =A4 /Table Col1 + Table Col7 | =A5/Table Col1 + Table Col7 |
- vanessafvgif you can provide some dummy data that would be useful.