Forum Discussion
AdministratorCan I create a measure that returns a specified date range? help I'm new using PBI,
I have a job in pbi where based on the maximum date of the context I must generate 8 months ahead and make some estimates using the data of the selected range of dechas. I made a separate calendar to use it in the second matrix q is generated from the maximum date, the problem is q grabs the maximum date of the main calendar and not the max date of the q context is the q I need.
2 Replies
- Idrissshatila
Super User
Hello Syndicate_Admin,
check this video for instructions https://www.youtube.com/watch?v=MhC4zj2byBQ&t=318s
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Syndicate_AdminIn this case it does not work for me, I think the dates are created from a maximum date of a slicer that I have and from that date generate 8 more months, do not enter them directly into dax. If you can see in the image the second inica matrix in April this is due to xq the maximum date of the data is April and what I want is q start from February 2021 q is the following month after 01/01/2021 the max date of the slice. And if the slicer changes date max, the second matrix trambien must start one month after the slicer.
