Forum Discussion
Problem on DAX average of
Hello and thanks for reply.
Yes the colum with date and time have type "date and time". There are any duplicate data and with manually calc i tax the sum of colum "pcsMin" and divide with number of row. And the other point..yes i've check that.
Hi lifesafari "duplicate data " is your issue mainly.
Still, I guess you have Calendar / Date table with
- year &
- week ID column
Put on visual your average measure (obviusly not from your example above) and put these columns from Calend / Date table and your results should be plausibale (Year and week ID guarantee unique values).
Hope this help, kudos appreciated.
Hello some_bih and thank to your replay. No, i not have a calendar table. This is a db with daily update..are there any problem with this? So ...wich is the best practice to create a calendar table for my job?
Hi lifesafari
Power BI you need Calendar / Date table as standard, minimum columns
https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables
In your case, as you are dealing with weeks, the best would be to use Bravo to automatically create weeks based on your dataset