Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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(...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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])))

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , upload on onedrive or dropbox and share link

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      You can find beelow the link to my sample data

       

      sample price .pbix 

       

      thanks a lot by advance

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        hi amitchandak 

         

        Do you have acces to the file ? 

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

         

        Thanks for your help

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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])))