Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to get the data from previous month and also that has a specific condition. I am using this formula:
count({<Column.Variable = {'Condition'}>}Column.Variable), count(InMonth(Date.DateAppointment,today(),-1), [Record_ID]))
I can use both conditions separate but cannot find the way them together to get the records for that specific condition for the previous month.
Thanks,
This might be what you are looking for.
=Count({$<Column.Variable = {'Condition'}, Date.DateAppointment = {"$(=MonthStart(AddMonths(Today(), -1)))<=$(=MonthEnd(AddMonths(Today(), -1)))"}>} [Record_ID])
It doesn't work, it gave me 0, I created a variable, this is what I have that also gave me 0:
Count({<ColumnVariable={'Reject'},Date.DateAppointment={'$(vPreviousMonth)'}>} Record_ID)
The reason could be that the dates are formatted differently.