Forum Discussion
Dynamic calculation in DAX using variable / lookup table?
I am wondering if it is possible to create a dynamic calculation in DAX. The denominator that I am using in the calculation may change based on a date and another attribute... What I am looking...
You should start capturing daily capcity in a seperate table. In addition, you should have a Date Dimension table for computing total days and slicing by Month. With these 2 it should be possible to achieve this easily in DAX.
Thank you. I have added a separate table for capacity and calendar. Because the reported results are required at a monthly aggregate level only for now, I have been able to undertake the joining and aggregation using power query.