Forum Discussion
sakamotothais
Helper III
Helper IIIComparison 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...
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])
Do you have a date table?
sakamotothaisHelper III
Helper IIIYes 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
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.
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
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.