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()

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

Ok, so as suggested i get this error.

 

Expression.SyntaxError: Token RightParen expected.

 

konstantinos's avatar
konstantinos
Icon for Memorable Member rankMemorable Member
10 years ago

You probably missed a parenthesis at the end