Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Select the last day value dynamically

Hi guys i am new to power bi i need to calculate the stock of the last day dynamically. For example i having stocks from january 2018 to November 2019. I want to calculate the last day stock value s...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my solution PBI file from here.

    Hope this helps.

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

Hi Anonymous ,

 

Here I have created a sample for your reference. We can use a measure as below to work it out.

Measure = 
VAR LASTDAY =
    CALCULATE ( MAX ( 'Table'[date] ), ALLSELECTED ( 'Table' ) )
RETURN
    CALCULATE (
        SUM ( 'Table'[value] ),
        FILTER ( 'Table', 'Table'[date] = LASTDAY )
    )

 

 

For more details, please check the pbix as attached.