Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
each not ([Day]=31 and [MonthName] = "August")