Calculated Measure Not showing up
I am trying to get a Prior Week measure to calculate from a Current Week measure. Other measures based off of the Current Week measure work but the measures based off of the Prior Week do not. Can anyone help me with this? I think it is an issue with the Prior week output value type but cant seem to figure it out. Current Week measure Calc: This works in all Current Week measures except Prior Week Prior Week measure Calc and Outputs: Do you know why or if there is a formula that call pull prior week from a long list of weeks with duplicates? Thanks Connor
Measure for Yearly Change is not dynanic with other fields
Hello, I have created a measure that shows the yearly change for applications. However, when I add this to a Matrix with other fields included (in this case 'FeeStatusGroup'), it does not show the yearly change for row field. The screenshot below shows the measure in question but also the table which has the total as correct, but the row/fee status data is not. I suspect I need to change the filter in the DAX but nothing seems to work so far. There will be other fields too that I will want to display in the same way of 'feestatusgroup' too. Thanks in advance for any help you are able to give.
