Forum Discussion
Dynamic max calcuation in Power Query
Hi, I am trying to calcualte a dynamic Max value from one column in Power Query Editor. An example below where I have different groups, I would like to be able to have dynamic Max value measurem...
I'm not entirly sure what you are trying to accomplish, but...
1. If you have loaded all the data you need to calculate the values, you should be able to write a dax measure which does what you want. Chances are one of the quick measures that is offered will work.
2. If you are using direct query, and have not loaded the data needed to calculate the value, then you will probably need to wait until the filter on parameter is implemented in Power Bi. Doing this your self is possible, but quite difficult, and has many caveats.