Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!
  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi  Anonymous 

    Please share your sample pbix file and  your expected output, that will be a great help.

     

    Regards,

    Lin