Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 can not get into the Dax function. Anyone have suggestions?
Column1 = IF(TODAY()-1 > TODAY(),"+","-")
Column2 = IF([value_flt_base], TODAY()-1 >[value_flt_base], TODAY(),"+","-")
Thanks
Solved! Go to Solution.
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])
I do not understand what you're trying to do with these formulas.
TODAY() - 1 will give you yesterday's date. So Column1 will always return "-" because yesterday's date is never greater than today's date.
Your Column2 is an IF statement with 5 arguments. The IF formula takes 3 arguments: IF(<condition to check>, <result if condition is true>, <result if condition is false>)
What does this table even look like? How would you compare one date's value to today's? Is there a date column? I'm not even sure this should be a column. This sounds like the sort of thing that should be a measure but it's very unclear from your examples.
Proud to be a Super User!
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.
Local | Date | Value |
Brazil | 20170621 | 174.52 |
EUA | 20170620 | 157.66 |
EUA | 20170621 | 487.69 |
Brazil | 20170620 | 497.65 |
Thanks
Do you have a date table?
Proud to be a Super User!
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 |
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) )
Proud to be a Super User!
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.
Use your date table and show this measure next to today's date.
Proud to be a Super User!
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()))
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |