Forum Discussion
Solved
Price Increase/Decrease Flag
Hi, I am trying to create a flag for price inc/dec where if the latest date is true in the ANY_PRICE_INC column it takes the date of the first Consecutive row. In this case for example the mos...
vivica19 I feel like I am still missing some critical information, but you could do this potentially:
Measure = VAR __CurrentDate = MAX( 'Table'[DATE] ) VAR __MaxDate = MAXX(ALLSELECTED('Table'), [DATE]) VAR __IsTrue = SELECTCOLUMNS(FILTER( ALLSELECTED( 'Table' ), [ANY_PRICE_INC] = TRUE() && [DATE] = __MaxDate ), "__AnyPriceInc", [ANY_PRICE_INC] ) VAR __MinDate = MINX( FILTER( ALLSELECTED('Table'), [ANY_PRICE_INC] = TRUE() ), [DATE] ) VAR __MinDateRate = MAXX( FILTER( ALLSELECTED( 'Table' ), [ANY_PRICE_INC] = TRUE() && [DATE] = __MinDate ), [ASP] ) VAR __Result = IF( __IsTrue && __CurrentDate = __MinDate, __MinDateRate, BLANK() ) RETURN __Result
the condition is IF the latest date value is TRUE, THEN return the first date that the price changed or the ASP value for that date. I need to create a flag for both Any price decrease and increase columns.
See the example in this table
| DATE | ASP | ANY_PRICE_DEC | ANY_PRICE_INC | First Time Price Changed FLAG |
| 8/26/2023 0:00 | $49.23 | FALSE | TRUE | Only if this value is TRUE |
| 8/19/2023 0:00 | $49.65 | FALSE | TRUE | |
| 8/12/2023 0:00 | $47.09 | FALSE | TRUE | |
| 8/5/2023 0:00 | $48.68 | FALSE | TRUE | |
| 6/24/2023 0:00 | $40.66 | FALSE | TRUE | |
| 6/17/2023 0:00 | $46.03 | FALSE | TRUE | |
| 6/10/2023 0:00 | $47.61 | FALSE | TRUE | |
| 6/3/2023 0:00 | $48.60 | FALSE | TRUE | |
| 5/27/2023 0:00 | $48.19 | FALSE | TRUE | |
| 5/20/2023 0:00 | $45.53 | FALSE | TRUE | |
| 5/13/2023 0:00 | $48.08 | FALSE | TRUE | |
| 5/6/2023 0:00 | $45.81 | FALSE | TRUE | $45.81 |
| 3/25/2023 0:00 | $39.15 | FALSE | FALSE | |
| 3/18/2023 0:00 | $38.77 | FALSE | FALSE |
vivica19 I feel like I am still missing some critical information, but you could do this potentially:
Measure =
VAR __CurrentDate = MAX( 'Table'[DATE] )
VAR __MaxDate = MAXX(ALLSELECTED('Table'), [DATE])
VAR __IsTrue = SELECTCOLUMNS(FILTER( ALLSELECTED( 'Table' ), [ANY_PRICE_INC] = TRUE() && [DATE] = __MaxDate ), "__AnyPriceInc", [ANY_PRICE_INC] )
VAR __MinDate = MINX( FILTER( ALLSELECTED('Table'), [ANY_PRICE_INC] = TRUE() ), [DATE] )
VAR __MinDateRate = MAXX( FILTER( ALLSELECTED( 'Table' ), [ANY_PRICE_INC] = TRUE() && [DATE] = __MinDate ), [ASP] )
VAR __Result = IF( __IsTrue && __CurrentDate = __MinDate, __MinDateRate, BLANK() )
RETURN
__Result
it worked perfectly well...!!! thanks sooooo much 🙂