Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Units Previous Month - Two Date Tables

I am trying to calculate the units fulfilled in a previous month. My table has two date tables. I need the data from the "Fulfillment" date table. This is the DAX formula I wrote. I received this er...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I ended up solving it. I had to use the fulfillment date table and use [Date] from there. Thanks!

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi Anonymous ,

 

It is odd that it doesnt work.  You can see in my screenshot below that it does.

Alternatively, try this

Previous Month2 = 
VAR __end =
    MIN ( Dates[Date] ) - 1
VAR __start =
    EOMONTH ( MIN ( Dates[Date] ), -2 ) + 1
RETURN
    CALCULATE ( [Sum of Values], DATESBETWEEN ( Dates[Date], __start, __end ) )