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])
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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

Awesome. Thank you!