Forum Discussion

Tony5's avatar
Tony5
Icon for Helper I rankHelper I
7 years ago
Solved

Formula with variable references

I have an Excel report I'm trying to recreate in PowerBI. But I'm stuck at the part where Excel uses match and offset statements to display sumif info based on a selection (see screenshot).   Was w...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Upload the file to OneDrive and share the download link.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

    • Tony5's avatar
      Tony5
      Icon for Helper I rankHelper I
      7 years ago

      Hi Ashish, my apologies for forgetting to mention that I'd prefer to not use unpivoting for the solution.

       

      Reasons is, for the actual file, I'll be working with millions of rows and more than a hundred metrics. Which will compound my unpivot into hundreds of millions of rows.

       

      Do you have any thoughts on a non pivot solution?

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        7 years ago

        Hi,

         

        No.  I do not have any other possible solution.