Forum Discussion
Pivoted Data and Potential Future Values
I have a .pbix file using the pivot columns feature in Power Query and I cannot figure out how to handle potential future values. These are values that are not a part of the dataset just yet, and the...
lbendlin
Super User
Super UserI have a .pbix file using the pivot columns feature in Power Query Don't do that. You get the pivoting for free in the Power BI visuals.
While I do agree, using the pivot column feature is bad practice, as I mentioned at the end of my question, I took this over from someone else and do not have the time to pull this whole thing apart and rebuild it.
So I am stuck with this for now, but my problem still stands. How can I handle future columns and perform DAX calculations using them before they are available?
- lbendlin
You cannot. Power BI is fundamentally incapable of doing that.
Spend the effort to rebuild.