Forum Discussion
Re: power query/ dax measure , multiple conditions/ multiple answers
Niels_83 , do you work only with years, or consider periods as months, quarters, YTD, etc.?
And it's not clear how to show result, perhaps you may expand your Answer sample with periods variances.
Also, perhaps "share accountmanagers" differ from period to period.
2 Replies
I have separate column for year (number) and month (text). It would be great if you have measure for variance in revenue in selected year (selected with slicer) compared to year-1. And maybe even year to month (cumulative). Something like (from pivot tabel):
Sorry, I didn't catch. Desired result doesn't look as PivotTable. For it we may have periods as columns, category as rows and one or two measures as aggregation for their intersection.
