PowerBi Desktop : Previous Semester Number Employees Filter by Slicer

[SergioPalhais]

Hello , i did some research but i wasn't able to find or adapt a solution to my project.

So my goal is to create a Card that shows the number of employee of the previous semester based in the selection of the "Data" slicer .

As you can see i was able to create the "Measure 3" that shows the current data selection -6 months

Now i want to show the employee numbers using "Measure 3" or some equivalent, that is able to do it using the Date selected in the "Data" -6 months / 1 semester.

This is my table:

This is measure 3:

Then i want to show only "Banco Montepio" but that i think i can do it applying a normal filter "Empresa" to the card visual 

Thanks

[SergioPalhais · Accepted solution]

ok , this is working now 

 CALCULATE(SUM(TrabalhadoresConverteBI[Ntrabalhadores]), FILTER(ALL(Semestres), 'Semestres'[SemesterRANK] =max(Semestres[SemesterRANK])-1))

For previous semester

Thanks

[SergioPalhais]

Still not working. I want to create a visual card that show the number of employees the previous semester of the one selected in the slicer, for example, with 30-06-2022 filter it will give me the employees of 31/12/2021 ( one semester before )

[amitchandak]

@SergioPalhais , Create a table with distinct semesters (Assume date or sortable column ). Join it back with you table.

Have rank on the semester start date 

A new column

semester  Rank = RANKX(all('Date'),'Date'[semester start date],,ASC,Dense)

These measures can help
This Week = CALCULATE(Count('Table'[Count]), FILTER(ALL('semester '),'semester '[semester Rank]=max('semester '[semester Rank])))
Last Week = CALCULATE(Count('Table'[Count]), FILTER(ALL('semester '),'semester '[semester Rank]=max('semester '[semester Rank])-1))

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s