Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

PowerBi Desktop : Previous Semester Number Employees Filter by Slicer

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

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    ok , this is working now 

     

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

    Thanks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    ok , this is working now 

     

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

    Thanks
  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

     

    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 )