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])

     

     

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])