Power BI
      Back to home
      1. Help Center
      2. Power BI

      How would you create trailing X month metrics via DAX against a non-standard calendar?

      The solution will involve:
       
      CALCULATE function to control (take over) filter context of measures.
      ALL to remove existing filters on the date dimension.
      FILTER to identify which rows of the date dimension to use.
      Alternatively, CONTAINS may be used:
       
      CALCULATE(FILTER(ALL(‘DATE’),…….))