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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
giorgiokatr
Helper V
Helper V

Values of latest date when two dates selected

Hi!

My table is like that

 

Date              Value

January          20

February          30

 

 

when i select only february or January the value is 30 or 20

but when i select two or more month i want the result not to be 50

i want the result to be 30 (the latest value off the dates selected

is it possible?

3 REPLIES 3
tringuyenminh92
Memorable Member
Memorable Member

For the original question, you just right click in Sales field of Card and choose Maximum. That's all. 

Screenshot 2016-11-29 23.18.57.png

 

And for the additional question, you could try below expression:

 

Calculated Measure - Good Sales (%) = Divide(calculate(sum(Amount[Good Sales])),calculate(sum(Amount[Sales])))

Screenshot 2016-11-29 23.26.03.png

BhaveshPatel
Community Champion
Community Champion

Yes, You can do that by explicily specifying the filter in the calcualte function. for this case,

 

Feb Only:=CALCULATE(SUM(Table(Value)), Table[Date]= "February")

 

There are many other ways you an write this expression. 

Providing Sample data will help us to give you a specific suggestion.

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.

Thanks!

I am attaching a sample pbix

In this example i have two tables (Dates and Amount)

Slicer has the dates and a Card has the Amounts

If i select january it show 20 but if i select february and march i dont want to show 70 but 40 (the sales of the last month)

 

 

Also i have another question

Table Amount has branches with areas

Each branch has Sales and Good Sales Column

So i created a new column which is Good Sales/ Sales  (% of good sales)

When i group by area (sheet good sales) is there any way to show the % of good sales for area

Right now Bi calculates the sum. I want to show the weighted average

 

https://drive.google.com/file/d/0Bw-_YmJ3Q49gMjJqbnRTeGIxRkU/view?usp=sharing

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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