Previous Period Not Grabbing in Measure
Looking for any assistance - I have date periods set for a date slicer ie "Last 30 Days" I have created start of this period, end of this period, start of previous period, end of previous period measures so that I can ensure the report is seeing the dates correctly. Where my report hits is snag is when I want to do a caluclation on the previous period. IE order count Current Period gives me a caluation with the below measure: Count of Orders Current Period = CALCULATE([Count of Orders], DATESBETWEEN( Dim_Date[CalendarDate], 'My Measures'[Start of This Period],'My Measures'[End of this Period])) When I apply the same logic to previous period I get blank Count of Orders Previous Period = CALCULATE([Count of Orders], DATESBETWEEN( Dim_Date[CalendarDate], 'My Measures'[Start of Previous Period],'My Measures'[End of Previous Period])) Any assistance is appreciated!
