Forum Discussion
Complex calculations on a pivot table
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) ...
Load your data set into the data model, and create a DAX measure. See tutorial below
https://youtu.be/e-CFYi52gpc
If you have a DAX measure question, ask it here Mr. Sergei Baklan is the DAX expert in the community