Forum Discussion
lifesafari
2 years agoHelper I
Problem on DAX average of
Hello i have a db connect with some columns. One of this is pcsMin, the quantity of pieces count by telemetry on each minute (for example 16/09/2023 10.01.00 -> 5 / 16/09/2013 10.02.00 -> 10). I need...
lifesafari
2 years agoHelper I
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?
some_bih
2 years agoCommunity Champion
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