topic Values of latest date when two dates selected in DAX Commands and Tips

Values of latest date when two dates selected

giorgiokatr — Sat, 12 Nov 2016 20:25:36 GMT

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?

BhaveshPatel — Sun, 13 Nov 2016 02:04:43 GMT

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.

giorgiokatr — Sun, 13 Nov 2016 12:28:05 GMT

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

tringuyenminh92 — Tue, 29 Nov 2016 16:31:15 GMT

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])))