Forum Discussion
Relative reference with measure
Is there a way to create a relative reference within a measure? In my model I currently need to update 6 different measures when we reach a certain point throughout the month. This point in the mo...
Thanks v-lili6-msft
Unfortunately I may not be fully understanding. I tried to follow the link you sent and was unsuccessful in getting the measure to function as expected.
My original formula is below and I have to manually update the Fiscal Period every month.
Selected HC VTF = if(HASONEFILTER('Z-Fiscal_Time'[Fiscal Period]),calculate(sum(EID_Table[Forecast People]),EID_Table[Staffing Type Category]="Regular"),calculate(sum(EID_Table[Forecast People]),EID_Table[Staffing Type Category]="Regular",'Z-Fiscal_Time'[Fiscal Period]="P11 - FY20")) -
if(HASONEFILTER('Z-Fiscal_Time'[Fiscal Period]),calculate(sum(EID_Table[Actual People]),EID_Table[Staffing Type Category]="Regular"),calculate(sum(EID_Table[Actual People]),EID_Table[Staffing Type Category]="Regular",'Z-Fiscal_Time'[Fiscal Period]="P11 - FY20"))
I have created a related table that I would like to be able to slice on instead of having to update the measure. With those details are you able to let me know of a way to replace the Fiscal Period?
Thanks!
hi Anonymous
Please share your sample pbix file and your expected output, that will be a great help.
Regards,
Lin