Converting Excel to DAX

Hi Sethforte1 ,

First of all your explanation is not the best one and your dataset is very complex to achieve any results withouth understanding what you want to have.

As a good practice check please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

Picking up your two table you refer I have made the following measure:

Measure =
DIVIDE (
    COUNT ( tbl_Import[Complete] );
    CALCULATE (
        SELECTEDVALUE ( tbl_DaysCount[Working Days-Holidays] );
        FILTER (
            tbl_DaysCount;
            tbl_DaysCount[Month] = MAX ( tbl_Import[Complete Month] )
        )
    )
)

This is not the optimal measure and need further explanation to help you better, and believe that the first step is to get a better data model in place.

Check the PBIX file with the chart and if it's working properly, if you can also give better insights would be helpfull