Forum Discussion

mikaro's avatar
mikaro
Frequent Visitor
9 years ago
Solved

Monthly inventory

My fact table consists of transactions where every row is either a negative or positive transaction ( i.e. profit or loss) and other info related to them.   I'm trying to figure out what is c...
Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    Hi mikaro,

     

    If you are finding cummulative value, it should be:

     

    cumulative qty = CALCULATE(
    SUM(
        Transactions[value]
        ),
        filter(
            ALL( Dates[Date]),Dates[Date] <=MAX(Dates[Date]) && year(Dates[Date])= year(MAX(Dates[Date]))
                ))

    and mapping relationship when using dates table

     

     

    if it's not your expectation, hope you describe your expectation resuslt again so i could quickly figure out solution.

mikaro's avatar
mikaro
Frequent Visitor
9 years ago

Hi tringuyenminh92,

 

Here are the files ppix and transactions.

 

I added some examples and text boxes that will hopefully explain and clarify this problem even more. If they dont help please let me know and i'll try to explain again.

 

Thanks!

tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
9 years ago

Hi mikaro,

 

If you are finding cummulative value, it should be:

 

cumulative qty = CALCULATE(
    SUM(
        Transactions[value]
        ),
        filter(
            ALL( Dates[Date]),Dates[Date] <=MAX(Dates[Date]) && year(Dates[Date])= year(MAX(Dates[Date]))
                ))

and mapping relationship when using dates table

 

 

if it's not your expectation, hope you describe your expectation resuslt again so i could quickly figure out solution.