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.
Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.