Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago

How to plot BS stock amount by year month ?

Hi All

Yesterday i created below post :-

https://community.powerbi.com/t5/Desktop/How-to-create-expression-for-display-BS-Stock-Amount/m-p/1694312#M673182

jdbuchanan71  sharing with me expression :-

_Stock Amount_JDBU = CALCULATE( [AMOUNT], GL[1_B_STK] = "STK" )
which able to display the correct stock amount using Card Vis.
Now i like to plot the Stock Amount Trend By Year Month.
 

 

The above trend don't look correct. As it should be all +ve or -ve value.

 

Paul

 
 
Need Help

3 Replies

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hello admin11 ,

     

    Do you have any negative values in your data pertaining to this negative Stock caluclation for certain months? Can you share your report removing all the sensitive data?

    Looks like the 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi admin11 ,

     

    I guess you want to sort by year month. Please kindly refer to

    how to sort Date (MonthYear column)?

     

     

     

    Best Regards,

    Stephen Tao

     

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