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

Hello,

 

There have been many requests for my actual data set which I am not sure is necessary.  This is a process driven question.  Within Excel there is the option to use the cell reference which can alter a calculation.  I am wondering if there is any way to do this in Power BI.

 

https://support.office.com/en-us/article/Switch-between-relative-absolute-and-mixed-references-DFEC08CD-AE65-4F56-839E-5F0D8D0BACA9 

 

https://edu.gcfglobal.org/en/excelformulas/relative-and-absolute-cell-references/1/

    • 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