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...
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.
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?