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

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.