Display latest percentage of action in Project

[ThuJa23]

Hi everyone, 

I have 2 tables, one is Calendar table and second is Project table.

Project table included Project titel, project % Action (% of progress for each project, which is updated mostly end of each month or beginning of next month), Date (which has relationship with Calendar table)

I would like to use Card as information to display the latest % Action of year when selecting each project titel. 

I tried DAX formular but it didn't display the right value, it shows Blank

Could you please hep me in this situation?

Thanks so much

Br,

Thu

[mh2587]

Latest % =

var maxDate = CALCULATE(MAX(tbl_projektfortschritt1[Fort/Percentage]),FILTER(tbl_projektfortschritt1,tbl_projektfortschritt1[Datum]))

return maxDate

create this measure then convert it to percentage

[amitchandak]

@ThuJa23 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[ThuJa23]

Hi @amitchandak 

I copy the data to excel and just change project title to ID to avoid sensitive information. 

https://docs.google.com/spreadsheets/d/1OWqzRg7jPyg5R9lp0ifNmGet48dxuBKd/edit?usp=sharing&ouid=10084...

You can download the file from this link

Thanks so much for your helps!

Br,

Thu

[v-rzhou-msft · Accepted solution]

Hi @ThuJa23 

I think you want to show latest percentage in card visual by measure. I use your sample to have a test.

Try this measure.

Latest Percentage = 
VAR _MAXDATE = MAX('Table'[Datum])
RETURN
CALCULATE(SUM('Table'[Fortschritt]),FILTER('Table','Table'[Datum] = _MAXDATE))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ThuJa23]

Hi @v-rzhou-msft ,

Sorry for my late replies! It definitely works to me, thanks so much 🙂

Br

Thu

[ThuJa23]

Hi @amitchandak ,

I try to share the sample data, but the problem the data source from Access file and my company is locked the data to export out. 

In Power BI, I also use connect data directly to Access file. 

I will try to create a sample data same as original one.

Thanks for your help

Br,

Thu