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...
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?
Hi,
No. I do not have any other possible solution.