Forum Discussion
Get Last value previous month
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])
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])))
6 Replies
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.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 ?
Anonymous , upload on onedrive or dropbox and share link
