Forum Discussion

MikeUS's avatar
MikeUS
Helper I
3 years ago

Wrong total values

Dear Community, have the following table below and receive the wrong column values. hope someone can help to fix that calculation.    DATE YEAR = Time Table DATE Month = Time Table   DATA 1 = DA...
Need Help
ToddChitt's avatar
ToddChitt
Super User
3 years ago

Can you explain, in plain language (not DAX or pseudo-code) what your final measure is supposed to represent?

And please include things like data types and/or units. Is DATA 6 currency? Data 3 is what? Price per unit, averaged over the year?

  • MikeUS's avatar
    MikeUS
    Helper I
    3 years ago

    Data 1 = Sales Quantity in Pieces

    Date 2 = Sales Amount in Currency

     

    Data 3 = Actual Sales Price in Currency

    Data 4 = Last Year Sales Price in Currency

    Data 5 = Actual Sales Price minus Sales Price last year in Currency to understand if Sales Price increased or decreased

    Data 6 = depending on the sales price development (increase or decrease) I earn more or less money. To understand the magnitude of my lost or win (today) I multiply the sales price difference with the quantity I have sold.

     

    Aim is do understand did I lose or make money overall as one item can be negative and I lose money but the portfolio overall should lead to more sales. In the example I actually lose 8400 USD (-8400)