Forum Discussion

Advocate II

8 years ago

Compare and alert when data got changed

Hi, I need a solution for the following query: I have a daily dataset that on a regular basis don't change at all, however when the percentage of "CapitalPercent" between days are changing I ...

Need Help

v-jiascu-msft

Microsoft Employee

8 years ago

Hi nhol,

Maybe you can try something like this: adding an arrow when the data changes.

If you want the exact formula, please provide your pbix file or a sample.

Measure 2 =
VAR lastdayQuantity =
    CALCULATE (
        SUM ( FactSales[SalesQuantity] ),
        PREVIOUSDAY ( 'DimDate'[Datekey] )
    )
VAR sumQuantity =
    SUM ( FactSales[SalesQuantity] )
RETURN
    IF (
        lastdayQuantity > sumQuantity,
        CONCATENATE ( sumQuantity, UNICHAR ( 9660 ) ),
        IF (
            lastdayQuantity = sumQuantity,
            sumQuantity,
            CONCATENATE ( sumQuantity, UNICHAR ( 9650 ) )
        )
    )