Forum Discussion

bignadad's avatar
bignadad
Icon for Helper I rankHelper I
2 years ago
Solved

Measures with no start date

I am working with leger entries and normally I can user the following to filter out the dates I want.   ..02/01/2024   This would show me all records with the end date less than Feb 1 2024   Bu...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    bignadad Best not to use the [Date].[Date] notation. Instead:

    Better RT =
        VAR __Date = MAX(MasterDate[Dates])
        VAR __Table = FILTER(ALLSELECTED(MasterDate),MasterDate[Dates] <= __Date)
    RETURN
        SUMX(__Table,[Invoiced Value])
bignadad's avatar
bignadad
Icon for Helper I rankHelper I
2 years ago

I tried the calculate type and that worked

Better RT =
CALCULATE(
  [Inventory Valuation],
  FILTER(
    CALCULATETABLE(
      SUMMARIZE(
        'MasterDate',
        'MasterDate'[Dates].[MonthNo],
        'MasterDate'[Dates].[Month]
      ),
      ALLSELECTED('MasterDate')
    ),
    ISONORAFTER(
      'MasterDate'[Dates].[MonthNo], MAX('MasterDate'[Dates].[MonthNo]), DESC,
      'MasterDate'[Dates].[Month], MAX('MasterDate'[Dates].[Month]), DESC
    )
  )
)