Forum Discussion
domi25
2 years agoFrequent Visitor
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.
each not ([Day]=31 and [MonthName] = "August")
1 Reply
- lbendlinSuper User
each not ([Day]=31 and [MonthName] = "August")