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.
Solved! Go to Solution.
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.
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?