Power BI Dax - New Column that shows text after a character or delimiter

Right click dataset> new column

Column name = Path

Source data = Area Path

 Path = right([Area Path], len([Area Path]) - search("\",[Area Path],,0))

Business Central - Financial Report - Formula to correctly compare periods including leap year day in filter

•  Use Comparison Date formula CM-1Y to correctly compare the entire month to month regardless of filter details
• -1Y will use exact dates