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

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

You probably missed a parenthesis at the end

CraigBlackman's avatar
CraigBlackman
Icon for Helper III rankHelper III
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

    It's obviosu when you take a step back. Missed the extra ), so we are all now working as i'd like!

     

    konstantinos thanks for the solution.

     

    Thanks everyone else too!