Forum Discussion

JesseV's avatar
JesseV
Frequent Visitor
4 years ago
Solved

measure that returns another column value based on the current month

I'm looking for a measure that returns the % based on the current month from the following table:     Datum (Date type) Verwachte voortgang (% type) Jan 9% Feb 18% Mar 28% Ap...
Need Help
  • JesseV's avatar
    JesseV
    4 years ago

    I ended up cracking it by adding Calculate before the whole thing:

    Verwachtte vooruitgang = 
CALCULATE(SELECTEDVALUE('Voortgang %'[Verwachte voortgang]),
    Filter('Voortgang %','Voortgang %'[Maand] = MONTH(TODAY()))
)

     
    Thanks a ton for your assistance onurbmiguel_ 

onurbmiguel_'s avatar
onurbmiguel_
Icon for Power Participant rankPower Participant
4 years ago

Hello Jesse 

Try like this 

 

Verwachtte vooruitgang = 
SELECTEDVALUE('Voortgang %'[Verwachte voortgang],
FILTER (ALL('Voortgang %'),'Voortgang %'[Datum].[Maand] = MONTH(TODAY())
))

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

  • JesseV's avatar
    JesseV
    Frequent Visitor
    4 years ago

    Hey onurbmiguel_ , thank you for replying.

     

    The measure gives an error: 'The expression references multiple columns. Multiple collumns cannot be converted to a scalair value' (attempted translation on my part ;))

     

    is this because the 'Verwachte voortgang' collumn has multiple %-ages ?

    • onurbmiguel_'s avatar
      onurbmiguel_
      Icon for Power Participant rankPower Participant
      4 years ago

      Hi again Jesse, 

      You can share some values ​​from the table to see the structure of the model, and if you are using a calendar table.

       

      BR 

      Bruno