Forum Discussion
Helper IIIHaving trouble with DAX formula
Hi,
I need to translate a formula into a dax measure.
The formula is: # new clients opened and billed this period/ total # of clients billed in the same period (not only new)
My data has a clients table with unique IDs per client, a created date for the client as well as a bills table with unique IDs per bill and the bill issue date.
I tried using CALCULATE (COUNT(Clients_ID)),Client_Creation_Date = Year (Today)),Bill_Issue_Date = Year (Today)) - For the New Clients portion of the formula (Numerator).
but it isn't working.
Can someone help? it's time sensitive.
It could be because you are comparing a full Date with a Year.
Try adding YEAR() to all the dates.
Year(Client_Creation_Date) = Year (Today())
Year(Bill_Issue_Date) = Year (Today())
8 Replies
AleResolver II
How is the relationship between these 2 tables (Client and Bills)? Do you have Client ID in your Bills table to join them?
- Ale
Can you then double check your DAX? The way you pasted here you are closing the CALCULATE bracket right after the COUNT, so the formula will not work as it ignores everything that comes after it.
CALCULATE (COUNT(Clients_ID)),Client_Creation_Date = Year (Today)),Bill_Issue_Date = Year (Today))
Try to remove that bracket (in red) and see if the formula works.
Joseph_HchaimeI got this error
- Joseph_Hchaime
Yes exactly. No issue with the relationship. It's the dax syntax that i'm having trouble with.
- Joseph_Hchaime
Yes exactly. No issue with the relationship. It's the dax syntax that i'm having trouble with.