Excel and DAX formulas for counting distict patient vists with variables

I need an excel formula and a separate DAX formula to count a large dataset of patient visits among many other data points. The count needs to be able to count only the patient account numbers that have charged dollar amounts against the account number by service date month of visit . Distinct count will not work. The account number is shown many times in one month's period since the patient will have many records in the charge month for multiple procedure codes, payment and adjustment activity. Distinct count would work if the patient was only seen once that month, but in the case the patient is seen a few times in a month. I need to be able to see the total visits by month and year and also be able to slice the data.

Készségek: Adatbevitel, Adatfeldolgozás, Excel, Statisztika, Visual Basic

Bővebben: I need excel work, i need excel help in agra, i need excel help, dax count number of occurrences, dax distinct count group by, dax countif measure, dax count rows in related table, countif in powerpivot, dax formula countx, dax count rows with filter, dax count rows with multiple filters, i need excel freelancer, need an excel expert to organize some data for me i need t, i need excel expert, i need excel data entry, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, excel ipad formulas, convert excel spreadsheet formulas webpage, excel spreadsheet formulas webpage, excel spreadsheet formulas

A munkaadóról:
( 0 értékelés ) United States

Projektazonosító: #16967848



Hello, I am a EXCEL EXPERT - Macros(VBA) with 10 years of Exprience. I have already completed About 2000+ On Various Freelance Websites I can give you quality work in quick time Thank you Mohammed Sutarw Több

$45 USD 1 napon belül
(43 értékelés)

6 szabadúszó tett átlagosan $26 árajánlatot erre a munkára


i can do this, i have more than 6 years experience of medical billing US based NASDAQ listed company. i have good command over ms excel especially pivot table, charts, advance formulas etc. Thanks. Please review my pro Több

$25 USD 1 napon belül
(9 vélemény)
$25 USD 1 napon belül
(2 vélemény)

Professional excel expert here i would like your excel work with ease and comfort let's get start' i am waiting for your respone

$10 USD 2 napon belül
(0 vélemény)

I have three years of data entry experience, and I have performed all of the duties listed in your job description. I type 42 wpm with almost 100% accuracy, and my employers have praised me for my focus, speed, accurac Több

$25 USD 1 napon belül
(0 vélemény)

You can send me your project I can easily complete and return you as possible in very low price

$25 USD 1 napon belül
(0 vélemény)