Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Dates & Value Difference

Hello,   I want to provide a comparison of sales value as of each date.    Example: Report Date Contracts Value 16/06/2021 10500 20/06/2021 13100 29/06/2021 9800 ...etc ...et...
Need Help
  • daxer-almighty's avatar
    daxer-almighty
    5 years ago
    [Positive Diffs Total] =
SUMX(
    SUMMARIZE(
        FactTable,
        // This CustomerID must be
        // unique. It's the key to
        // the Customer dimension.
        Customers[CustomerID]
    ),
    MAX(
        // blank is treated as 0
        // but will not display
        BLANK(), 
        [New Contracts Financial Reporting] 
    )
)

[Negative Diffs Total] =
SUMX(
    SUMMARIZE(
        FactTable,
        // This CustomerID must be
        // unique. It's the key to
        // the Customer dimension.
        Customers[CustomerID]
    ),
    MIN(
        // blank is treated as 0
        // but will not display
        BLANK(), 
        [New Contracts Financial Reporting] 
    )
)
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

You can use the following two measures for two cards:

increased contracts = SUMX(FILTER( SUMMARIZE(FactTable,FactTable[CustomerID],"_increasedvalue",[New Contracts Financial Reporting]),[_increasedvalue]>=0),[_increasedvalue])

Decreased contracts = SUMX(FILTER( SUMMARIZE(FactTable,FactTable[CustomerID],"_decreasedvalue",[New Contracts Financial Reporting]),[_decreasedvalue]<=0),[_decreasedvalue])

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai