Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Balance from latest transaction number

Hi All,    I have some tenancies that have had more than one transaction in a week and I only want to display the latest one (sorted by transaction number) and display the balance alongside it.   ...
Need Help
Show and Tell
Tips and Tricks
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


Best regards,

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for this. However as there are many tenancies on the visual, it only shows 1 for the lastest transaction number regardless of the tenancy number. Is there a way I can make this measue specific to each tenancy? Thanks

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    We can use the following measure to meet your requirement:

     

    IsLastNumber = IF(CALCULATE(MAX('Table'[Transaction Number]),FILTER(ALLSELECTED('Table'),'Table'[Tenancy] in FILTERS('Table'[Tenancy]) && 'Table'[Transaction date] in FILTERS('Table'[Transaction date]))) in FILTERS('Table'[Transaction Number]),1, -1)

     

     


    Best regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lid-msft, 

       

      Thanks for the suggestion. However, I'm getting the number 1 for all of them now and now just the latest transaction per tenancy. 

       

       
      • v-lid-msft's avatar
        v-lid-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        If you mean that the Transaction are all shown as 1, could you please set it as "Do not summarize" in the value field of table visual?


        Best regards,