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

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 ❤️