Forum Discussion

Tony5's avatar
Tony5
Helper 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 wondering if anybody has any idea how I should tackle this in PBI? I can attach the XLSX file. Just not sure where to upload it to.

 

Need Help

9 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    I understand Metric C is an input.  What is the relevance of numbr 3?  Share your Excel file with formulas so i can understand your Excel formula and translate that into DAX.

    • Tony5's avatar
      Tony5
      Helper I
      7 years ago
      That was simply the output of the match formula. Not necessary for display to be honest.
      Hmm...i dont think I can upload an attachment via forum. Any advise how I can send/share the Excel file to you?