Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Any suggestions on creating a custom column to identify data for last month?
Date table shown below. If the currenly in October 2023. I would like to see only data from September 2023 to today. This should be dynamic from month to month.
This effort is to reduce the number of rows queried, improve performance.
Thanks!!
Julie Bunavicz
Solved! Go to Solution.
Here is one method that should work for you. Create a CustomColumn:
Date.IsInPreviousNMonths( [Date],1) or
Date.IsInCurrentMonth( [Date] )
Then apply a Filter for "True"
Hope this works for you.
Regards,
That works nicely. Thanks!!
Here is one method that should work for you. Create a CustomColumn:
Date.IsInPreviousNMonths( [Date],1) or
Date.IsInCurrentMonth( [Date] )
Then apply a Filter for "True"
Hope this works for you.
Regards,