Forum Discussion
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...
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.
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?
Hmm...i dont think I can upload an attachment via forum. Any advise how I can send/share the Excel file to you?
Upload the file to OneDrive and share the download link.
Thank you for the tip Ashish_Mathur . I've uploaded my file to my Onedrive.