Forum Discussion

Jensej's avatar
Jensej
Helper V
5 years ago
Solved

Using values from a Visual filter in a measure

Hello!    So i have a yearly Target Amount stored in a table. 15 780.-   Now i have a visual where my target value is 15 780.-. In my visual im able to filter the months if i for example want to ...
Need Help
  • darentengmfs's avatar
    darentengmfs
    5 years ago

    Jensej 

     

    I apologize for the misplaced " in the formula.

     

    Before you create the date column, click on Month, change the data type to text. Same thing goes to year. Then, you create the date column, after that, change the data type of the date column to date.

Jensej's avatar
Jensej
Helper V
5 years ago

Tried this one 

 

Rest of the World -

Date:  "1/" & [Month] & "/" & "[Year]

 

It shows an error right away so i took the " before the Year away so i could save. Like this

Rest of the World -

Date:  "1/" & [Month] & "/" & [Year]

 

Now i get an error saying. Expression.Error: We cannot apply operator & to types text and number...

darentengmfs's avatar
darentengmfs
Post Prodigy
5 years ago

Jensej 

 

I apologize for the misplaced " in the formula.

 

Before you create the date column, click on Month, change the data type to text. Same thing goes to year. Then, you create the date column, after that, change the data type of the date column to date.