Current month data

[joshrussin]

Trying to figure out how to calculate current month processes.

expression:

=Sum({$<Status_Dash={'Completed'}, Month={"$(Month(addmonths(today(),-0)))"}>} Processed_Dash)

the return value should be 4342, but it is returning all data from "completed" in the database, including previous months.

[Anonymous]

Sunny has the right idea.  However if your data crosses years you'll also want to include Year into the calculation.

LOAD

  Date_Dash,

  Month(Date_Dash) as Month,

Year(Date_Dash) as Year,

  Program_Dash,

  UOM_Dash,

  Status_Dash,

  Ave_Cost_Dash,

  Processed_Dash

FROM [lib://AttachedFiles/OB_Summary_Data.xlsx]

(ooxml, embedded labels, table is OB_Dash_Data);

Then your expression is

=Sum({$<Status_Dash={'Completed'}, Month= {"$(=Month(Today()))"}, Year= {"$(=Year(Today()))"}>} Processed_Dash)