Forum Discussion

sakamotothais's avatar
sakamotothais
Helper III
9 years ago
Solved

Comparison function with if in Dax

  Good afternoon, I am trying to compare values ​​between today's date and yesterday's date. And I want to create an alert where it decreases and where it increases from yesterday to today. But I c...
Need Help
  • sakamotothais's avatar
    sakamotothais
    9 years ago

     

    I'm using it as a solution:

     

    SUMX (
    FILTER (QL2_Alerts, QL2_Alerts[dtt_data_captura] = MAX (QL2_Alerts[dtt_data_captura])),
    QL2_Alerts[flt_base])

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Use your date table and show this measure next to today's date.

sakamotothais's avatar
sakamotothais
Helper III
9 years ago

 

I do not know how, I want to fix this measurement of today date. And compare with other reporting dates through filters. But today it has to be fixed.

 

Something like

CALCULATE(SUM(QL2_Alerts[flt_base],TODAY()))

  • sakamotothais's avatar
    sakamotothais
    Helper III
    9 years ago

     

    I'm using it as a solution:

     

    SUMX (
    FILTER (QL2_Alerts, QL2_Alerts[dtt_data_captura] = MAX (QL2_Alerts[dtt_data_captura])),
    QL2_Alerts[flt_base])