Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to make comparisons with float in DAX?

Hi everyone, hope you are well šŸ™‚   I'm trying to make a measurement that, depending on the daily variation, displays an icon for positive or negative. But if the number the variation has decimal ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    I checked your measure 'indicador base64' and found that you have offset the calendar table by one day.

    DateADD(
    oCalendario[Date],
    -1,
    Day
)

    You may need to remove this filter. The code in the SWITCH section  is sufficient for your needs.

     

    Best Regards,
    Community Support Team _ Eason

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
4 years ago

Hi Anonymous ,

Usually defining Indicators should be done on the Number and not on the percentage.

i.e. Control the display of Indicator using the Number by keeping the value as a number datatype and just  for display make the number as percentage

 

May be this could solve this issue!!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

 

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous 

    I checked your measure 'indicador base64' and found that you have offset the calendar table by one day.

    DateADD(
    oCalendario[Date],
    -1,
    Day
)

    You may need to remove this filter. The code in the SWITCH section  is sufficient for your needs.

     

    Best Regards,
    Community Support Team _ Eason

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thx ā¤ļø