Forum Discussion
/ 30 (days)
Add another ) after 0 ) so you will have there 0 )),
- Average Durations =CALCULATE (AVERAGEX (VALUES ( 'Calendar'[Date] ),COALESCE ( [SDR ID average per CP ID], 0 )),'FACT TABLE'[Charger Type] = 'Active'That does look good, the problem is that I am getting an error: 'Cannot find table 'Active'.
I do not have a table with Active/Non Active column.
Is there a different way of doing this. My line graph is showing "0" according to the calendar before the item started operating and runs into the future months (I guess as per the calendar). Well, that is because you replace blank with 0 in your original measure.
So forget what we did, it's not related to your issue.
Why did you replace the blank with 0 inside the coalesce? You have blanks inside the range?
Anyway, if you share the file and what you need I could solve this quickly. Will need to continue later, going away from PC, so will ping here later tonight. Until then please try to share the file or a sample of it.
P.S. appreciate your kudos
I do not have a table with Active/Non Active column.
Is there a different way of doing this. My line graph is showing "0" according to the calendar before the item started operating and runs into the future months (I guess as per the calendar).
Community ChampionWell, that is because you replace blank with 0 in your original measure.
So forget what we did, it's not related to your issue.
Why did you replace the blank with 0 inside the coalesce? You have blanks inside the range?
Anyway, if you share the file and what you need I could solve this quickly. Will need to continue later, going away from PC, so will ping here later tonight. Until then please try to share the file or a sample of it.
P.S. appreciate your kudos
Thank you very much, I will share that with you later.
Best wishes,
JHi SpartaBI,
I'm very gratefull for your assistance.This function I currently use:
Average Sessions =
AVERAGEX (
VALUES ( 'Calendar'[Date] ),
COALESCE ( [SDR ID average per CP ID], 0 )
)
This is the formula that sort of works. It returns the results correctly, averaging the usage data including the days when the unit wasn’t in use, but the issue is that My calendar starts in 2020 so the formula calculates the Averages from 2020 not when my Connector was first used in 2021 Q3, and runs to Q4 2022, as per my calendar.
I just need the function to calculate all the O’s between the 1st use until last usage, e.g. today.With this function I am calculating the SDR ID(unique number) Average per CP ID (unit number) Average, per day;
Some days the items are not in use, so that’s why I thought I need to add the coalesce calculation.
I am filtering the above function by the column (FACT TABLE[Connector]).
Please let me know if there's anything else you need to figure this out.
Thanks again,J
- SpartaBI
Hey, won't be able today. Tomorrow ping me here and we'll do a quick zoom to look together