Forum Discussion
New Measure based on Measure
Hi, I have no idea if this is possible and I have been pottering about forums but haven't come across anything that works. I have this data, which if plotted into a table visual shows me th...
Hi AmyMisa ,
From what I am understanding, delta is a measure, right?
You could create a new measure to return the current week's delta:
Current Week =
SUMX (
FILTER ( ALLSELECTED ( 'TABLE NAME' ), [Week Number] = WEEKNUM ( TODAY (), 2 ) ),
[Delta]
)
Previous week's delta:
Previous Week =
SUMX (
FILTER ( ALLSELECTED ( 'TABLE NAME' ), [Week Number] = WEEKNUM ( TODAY (), 2 ) )-1,
[Delta]
)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.