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 have three columns.

The Date, Place and Value

I want to compare the Value of yesterday's date d-1 with the value of today's date d0,

to check if there was an increase or decrease between yesterday and today.

In which localities there was increase and which localities had reduction.

 

LocalDateValue
Brazil20170621174.52
EUA20170620157.66
EUA 20170621487.69
Brazil 20170620497.65

 

Thanks 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Do you have a date table?

  • sakamotothais's avatar
    sakamotothais
    Helper III
    9 years ago

    Yes I have

     

     

    dtt_date
    6/20/2017
    6/20/2017
    6/20/2017
    6/20/2017
    6/21/2017
    6/21/2017
    6/21/2017
    6/21/2017
    • sakamotothais's avatar
      sakamotothais
      Helper III
      9 years ago

      I want to use a Dax calculation that checks the variance by selecting yesterday's date and today's date in the result, which increased and decreased.

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