Forum Discussion

CraigBlackman's avatar
CraigBlackman
Icon for Helper III rankHelper III
10 years ago
Solved

Future dates displayed and should not be.

I have a simple table that list the date, net sales an previosu years sales  using the following formula   P/Y Sales = SUMX(DimDate,CALCULATE([Net Sales],DATEADD(DimDate[Date],-1,YEAR))).   Probl...
Need Help
Show and Tell
  • CraigBlackman's avatar
    CraigBlackman
    10 years ago

    This is what I have

     

    = Table.SelectRows(#"Renamed Columns1", each [Date] <= DateTime.LocalNow()

elliotdixon's avatar
elliotdixon
Icon for Responsive Resident rankResponsive Resident
10 years ago

HI CraigBlackman In my dates table I have a column 

IsInCurrentYear = if(YEAR(NOW())= [Year],1,0)

You could add this to your dates table and then filter on it - something like

P/Y Sales = SUMX(DimDate,CALCULATE([Net Sales],DATEADD(DimDate[Date],-1,YEAR)),filter(DimDate,DimDate[IsInCurrentYear]=1))

ED