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.
We are excited to announce the Power BI Super Users!
Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.