Forum Discussion

Sand36's avatar
Sand36
New Member
9 months ago
Solved

impact % h on company, Ranking

I have a fact table with these relevant columns: Zlecenie – the order/job id RBH – hours  Nazwa_APT_FZ – company name (optional filter) Rodzaj_towaru – product type (will be on a slicer) ...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    9 months ago

    Hi Sand36,

    Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to ThomasWeppler, for his inputs on this thread. I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.

    outcome:

     


    I am also including .pbix file for your better understanding, please have a look into it.

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

ThomasWeppler's avatar
ThomasWeppler
Impactful Individual
9 months ago

When you say the impact on reducing do you mean how many procent the hours a company uses has changed since the same periode last year?