Formula specific for Matrix

Hi everyone!

I am working on a New Vendor by Year analysis dashboard and need to make a formula based off of a matrix visual. I am trying to determine new vendors if in the previous year, the vendor has no value. For example in the picture I uploaded, the second row will be a new vendor because they have no value in 2017 but they do in 2018. Because I used the Year column as my headers, I cannot “call” it in a measure or calculated column. Any advice? Thank you so much!


Hello @msheladia… Welcome to Enterprise DNA community forum and thank you for posting your query. I believe you should be able to use the YEAR(Today() -3 ) DAx function to get the year in the formula/measure you are trying to build. If you can post your PBIX file I can take a look and let you know if there is a better way of doing what you looking to do.

Hope you have a great Day


Thanks for posting your question @msheladia. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.

Hi @msheladia, we’ve noticed that no response has been received from you since the 8th of July. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!