Hi..I am using datesinperiod function for a measure given below:
CALCULATE(SUM('Demand Planning'[QtyIssuedFromStore]),DATESINPERIOD('Activity Date'[FullDate],LASTDATE('Activity Date'[FullDate]),0-MAX('Configurable Values'[Consumption Period]),DAY))
Here 'Demand Planning' is a fact table and 'Configurable Values' is a user table and has no relationship with any table and 'consumption period' is its column. The value works fine. All it does is to get the sum of the quantities for the user entered values for last days (for example user enters 30 so we get 30 days back quantities). When i put in the measure it shows me blank. After i put dates and corresponding values only i get results.
The users are asking to see a sum of the values irregardless of dates. So, they want to see the total values for the demand planning. I used all and all except statements to get the values of all but it does not work. Please let me know how i can include ALL or ALL EXCEPT in dates in period.
