Get Last value previous month

[Anonymous]

Hi,

I need your help. I would like retreive the last value on previous calendar to a specific month.

My data are :

receipt line

i create this measure

Mt YTD = TOTALYTD(SUM(ReceiptLine[MT Recept]),ReceiptDate[Date]  )

Qte YTD = TOTALYTD(SUM(ReceiptLine[Qte recept]),ReceiptDate[Date] )

Price N = DIVIDE([Mt YTD],[Qte YTD] )*

Price N-1 = IF([Mt YTD-1],
                 DIVIDE([Mt YTD-1],[Qte YTD-1])
                , [Price N])

Mt YTD (Price N-1) = SUMX( 
             ADDCOLUMNS( 
                    Summarize( ReceiptLine, ReceiptLine[ITEMID], ReceiptLine[ItempGroup], ReceiptLine[categorie appro],ReceiptDate[AnneMois])
                ,"_Mt au PRI N-1", [Qte YTD]*[Price N-1])
            , [_Mt au PRI N-1])

the final result on this report are

 So I would like the empty month are fileld by the last value like this

During my test, i created a new table base on previous formula  

Table = ADDCOLUMNS( 
                    Summarize( ReceiptLine, ReceiptLine[ITEMID], ReceiptLine[ItempGroup], ReceiptLine[categorie appro],ReceiptDate[AnneMois])
                ,"_Mt au PRI N-1", [Qte YTD]*[Price N-1]
                ,"PRI N-1", [Price N-1]
                , "Qt ", [Qte YTD])

the result like this

How can i modify my measure "Mt YTD (Price N-1)" to have a correct data for empry month ?

thanks a lot for your help

[amitchandak]

@Anonymous , the expected value is not clear

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Anonymous]

hi @amitchandak 

i created a new pbix file without sensitive data based on my screenshot but i can't upload it (file type is not supported)

How can i share it ?

[amitchandak]

@Anonymous , upload on onedrive or dropbox and share link

[Anonymous · Accepted solution]

@amitchandak 

i found the solution with this table definition and new measure 

receipt Group = ADDCOLUMNS( 
                    Summarize( ReceiptLine, ReceiptLine[ITEMID],ReceiptDate[Year-month],ReceiptDate[Year])
                ,"_Mt au PRI N-1", [Qte YTD]*[Price N-1])


new measure
==>
test = CALCULATE(max('receipt Group'[_Mt au PRI N-1]),Filter('receipt Group','receipt Group'[Year]=SELECTEDVALUE(ReceiptDate[Year]) && 'receipt Group'[Year-month]<= SELECTEDVALUE(ReceiptDate[Year-month])))

[Anonymous]

You can find beelow the link to my sample data

sample price .pbix 

thanks a lot by advance

[Anonymous]

hi @amitchandak 

Do you have acces to the file ? 

If yes, do you have any idea on my issue ?

Thanks for your help