Forum Discussion
Solved
How to filter data from a data table using a date selector together with specific conditons
Hello I have a data table consisting of deferral schedules from which I need to create a table showing transactions for each schedule by period, based on a date slicer. If the schedule document ...
SueM , If you have date Table, You can create a measure like, In that case, Transaction date or schedule date should be joined with date table and date column from date table should be used
Then have measure like
CALCULATE(Schedule[Total TranAmt],DATEADD(Date[Date],X,MONTH))
CALCULATE(Schedule[Total TranAmt],DATEADD(Date[Date],1,MONTH))
SueM , If you have date Table, You can create a measure like, In that case, Transaction date or schedule date should be joined with date table and date column from date table should be used
Then have measure like
CALCULATE(Schedule[Total TranAmt],DATEADD(Date[Date],X,MONTH))
CALCULATE(Schedule[Total TranAmt],DATEADD(Date[Date],1,MONTH))