cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Memorable Member

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

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

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

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.
Helper V

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

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors