I want to track the presence/absence of a serial number over different months.
My initial data looks like:
I want to know if a serial number existed in the previous month or if it will exist in the next month. The output I'd like to obtain is:
Ideally, I would like to use a M function to get that table, but a DAX expression would suffice.
Solved! Go to Solution.
The expression works correctly. However, I want to use it for filtering purposes in the visualisation and I don't think I can do so. I'm thinking about using an R query to create the value, but, I rather do it as a M query.
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.