Oct 16 2021 01:10 PM
I have a large database and pivot table, with monthly data. I created a sample database to show you the problem I am having.
The underlying data looks something like this (just clipped a few lines)
account | name | month | sales |
1090 | Hertz | Jan-21 | 13 |
1090 | Hertz | Feb-21 | 7 |
1090 | Hertz | Mar-21 | 8 |
1090 | Hertz | Apr-21 | 2 |
1121 | Avis | Jan-21 | 4 |
1121 | Avis | Feb-21 | 7 |
1121 | Avis | Mar-21 | 9 |
The resulting pivot returns this
What I want to do is display only the accounts where sales in 2 of the last 3 months are 5 or less.
I tried calculated items - but on my original pivot table this results in an error " too many records"
I've tried other iterations, none work without a ton of manual intervention.
Can someone point me in the direction of a solution or a hack?
Oct 16 2021 05:25 PM - edited Oct 16 2021 05:29 PM
Load your data set into the data model, and create a DAX measure. See tutorial below
If you have a DAX measure question, ask it here Mr. Sergei Baklan is the DAX expert in the community