Calculate value based on Dropdown

[srqdewfffffffff]

Hi everyone,

I have a dropdown DataCardValue144_1 (Mês) where I have all the months (January to December) and each month has a multiplier factor of 12 to 1, respectively. 

When I select a month like July it multiples the value from DataCardValue150_4 = 10000 (Total Mensal) with the number 6, and the result in Label39_5 (Total Ano) is 60000.

This is my code inside Label39_5:

If(DataCardValue144_1.Selected.Value = "Julho"; Text(Value(DataCardValue150_4*6)); "")

I want to know if is possible to make this code work to all months inside Label39_5.

Today I make it work with 12 labels that are only visible when a especific month is choose on the dropdown.

Thanks for the help!

[CarlosFigueira · Accepted solution]

Hello @srqdewfffffffff 

The Items property of the dropdown can be a table with multiple columns. So if you set it to the following expression:

Table(
  { Nome: "Janeiro"; Multiplicador: 12 };
  { Nome: "Fevereiro"; Multiplicador: 11 };
  { Nome: "Março"; Multiplicador: 10 };
  { Nome: "Abril"; Multiplicador: 9 };
  { Nome: "Maio"; Multiplicador: 8 };
  { Nome: "Junho"; Multiplicador: 7 };
  { Nome: "Julho"; Multiplicador: 6 };
  { Nome: "Agosto"; Multiplicador: 5 };
  { Nome: "Setembro"; Multiplicador: 4 };
  { Nome: "Outubro"; Multiplicador: 3 };
  { Nome: "Novembro"; Multiplicador: 2 };
  { Nome: "Dezembro"; Multiplicador: 1 };
)

You can update the code in your label to something along the lines of

Text(Value(DataCardValue150_4.Text) * DataCardValue144_1.Selected.Multiplicador)

Hope this helps!

[srqdewfffffffff]

Sorry for the delay! 
This solution worked for me!  
Thank you so much, @CarlosFigueira