Forum Discussion

domi25's avatar
domi25
Frequent Visitor
2 years ago
Solved

Remove only one date from Calendar table

Hi, 

I have a dataflow with Fiscal Calendar. I need to remove only one date for each year from the calendar -> 31 August. I have separate columns for day and month. I tried to filter it out by:

But this solution removes days in August and all 31 days and I only want to remove 31 Ausust from the data. 

1 Reply

  • each not ([Day]=31 and [MonthName] = "August")