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

This measure would return the difference between one day and the previous day. Not literally today and yesterday unless you give it today's date from the date table, but any 2 day period based on the date from your date table.

 

Daily Variance = SUM(TableName[Value]) - CALCULATE(
	DATEADD(DateTable[dtt_date], -1, day)
)
sakamotothais's avatar
sakamotothais
Helper III
9 years ago

It does not work for me. I want to bring a measure of only the result of today's date. A measure that filters only the sum of today's date.

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