Hello everyone. I'm here again asking for your help. I have a question for you. I have the following report with the headings of the months of the year which are descriptively but linked to the numbers of the months (1,2, etc).
For now I take the current month for example December and the previous month for each year in this example November. I would like that given two years, for example 2020 and 2019, I can take for the previous year, and only for that, only the month with the largest number. To make you understand better: data two years 2020 and 2019, I now take December and November 2020 and December and November 2019. I would like to take December and November 2020 and December 2019. Of course, the choice of months can change, it is not always November and December but it can also be January and February together
@tarz , one way is you create a trailing year measure and use that.
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacadsqlbiMy Video Series Appreciate your Kudos.
Hello @Daviejoe and @amitchandak Yes, I have already created the view via direct consultation and in the consultation I take today's year and the previous year, both today's year and the previous year took two months, one month of reference and the previous month. But what I want is to take only today's month and the month before today's year and today's month of the previous year Type: 2019 month 2, 2020 month 2 and 1 to understand. I thought of two ways to do this, either through the power bi view, for example, with a measure, or through consultation, but I don't know how to do it.