Forum Discussion
Dax Formula Help - Similar to Left Join Sum
hi, amotto11
Why AQ2017Q4 and MQ12 is 3, MQ9 is the last for this row, it has no data after MQ12, and AQ2018Q1 has the same data
with AQ2017Q4, Why AQ2018Q1 is 1 2 3, but AQ2017Q4 is 1 2 3 3?
Best Regards,
Lin
The simple answer is because it will complete the triangle. The long answer is pretty complicated and probably out of the scope of this thread. Basically you can think of AQ as a quarter and anything that happens in that quarter is captured along that row. The MQ is the maturity. Everything that happens during the quarter is contained in the 3 bucket, everything that happens in the next quarter that is associated with the last quarter is captured in the 6 bucket and so on and so forth. If nothing occured in the 12 bucket, it would be blank in my data because my data is incremental, i am looking to make it cumulative, since the quarter is 12 months old, the cumulative amount would still be the same as the 9 month old period.
The more you ask questions the more lights are going off in my head. Could you create a calculated column in the combined table that sums the data[amount] that is equal to the AQ but less than or equal to the MQ. Since all possible scenarios are contained in the combined table, would that work? Would you be able to help me with this?
Thanks again for all of your help!