Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HenrikThomsen
Frequent Visitor

First and last value from selection using timeline slicer

I am new to Power BI and might not fully have grasped the copnsept of measures, coloumns and selections.

 

My problem is that I have a data set and are trying to create a report showing the beginning-of-period value, flows in period and end-of-period value. I have added the timeline slicer for period selection.

 

Data are like (simplified):

Date  Value  Flow

1        5         7

2        12      -2

3        10      -5

4        5        1

5        6        7

 

I have created a measure called ToDate = CALCULATE(Max(Date),ALLSELECTED(Table))

and a column called UlitmoValue = if(Date=ToDate,Value,0)

 

If I insert the measure ToDate in a card in my report it shows the date chosen from the slider.

If I insert the column UltimoValue in a card it also show the right value - but only when the entire period is chosen from the slider. If I change the end-date using the slider it shows 0.

A card with the sum of Flow works well in connection with the timeline slider.

 

How do I create a field that show the value at the end (and also of the beginning) of my chosen period? Thank you in advance.

1 ACCEPTED SOLUTION
BhaveshPatel
Community Champion
Community Champion

See the below post from Herbert_Liu. It has a secret of calculating the results as per required.

 

http://community.powerbi.com/t5/Desktop/Display-Week-end-Friday-or-Month-End-results-based-on-filter...

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

3 REPLIES 3
BhaveshPatel
Community Champion
Community Champion

See the below post from Herbert_Liu. It has a secret of calculating the results as per required.

 

http://community.powerbi.com/t5/Desktop/Display-Week-end-Friday-or-Month-End-results-based-on-filter...

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Thank you Bhavesh

 

Understood the concept and was able to make somewhat similar formulas showing the wanted results.

Power BI and its possibilities keeps surprising me positively.

 

Henrik

Once Concept is clear, All runs like Magic.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.