In this scenario, we start with a calendar and we want to obtain the last month included in it, regardless of the filters that may be applied to the data model. In our example, this calendar will include, in addition to the date field, a field with the year, month... and a text field in which the year and month of each date have been concatenated (in text format), ensuring that the result has 6 characters in length (or, in other words, ensuring that the month is represented with two digits). This can be done in the query editor by creating a custom column with the following M code.

A common scenario is one in which we want to evaluate the accumulated total, including all data up to a certain date and not just those involved in the current filter context. For example, if we assume the existence of a sales table Sales that contains an Amount column with the sales figure, we could define a measure that calculates the sum of this column with the following DAX expression:

Writing a book is a desire that, consciously or unconsciously, many of us have. At the end of the day, it is proof that we have a certain knowledge on a subject that allows us to adopt that role of "teacher". I -who have spent 25 years dedicating myself to a greater or lesser extent to teaching- always had in mind the idea of writing one, although it was never more than an idea, because too many doubts came to mind: will there be any interested publisher? How long would it take? Do you get a fee per book sold?

The re.DOTALL search modifier forces the symbol . represent any character, including the newline symbol \n.

The re.MULTILINE search modifier forces the ^ symbol to match at the beginning of each line of text (and not just the first), and the $ symbol to match at the end of each line of text (and not just the last one).