Forum Discussion

knut12212's avatar
knut12212
Icon for Helper I rankHelper I
1 year ago
Solved

Insert values in a matrix by using a measure

Hey guys, does someone know what's wrong with my measure? I would like to create a measure that looks at the date per line and then enters a number in the respective month. For the date of PM040, 4...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi knut12212,

    Thank you for reaching out to the Microsoft Community Forum.

     

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
    Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
    Please show the expected outcome based on the sample data you provided.

     

     

    If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

     

    Thank you

sjoerdvn's avatar
sjoerdvn
Icon for Solution Sage rankSolution Sage
1 year ago

That "Start of the Month" column, how is that defined? Is it a Calendar table column? Is the same value for all days in a month? Also, you what do you want to display if approval/bid submission/cs bi submission happen in the same month.
The measure code as text, and some test data would also be nice.
Like I mentioned earlier, any solution will include CALCULATE and USERELATIONSHIP. But since the two tables here are joined on Date, there is no need for the bulky expressions used here.