Forum Discussion
Actual VS. Targeted Benchmarks
Hi Intermountain ，
From your description, you may need a calendar table, an employee information table, a table describing production information, then create relationships using the date table with the employee information table linked to the production information table, and finally create metrics, calculated columns or calculated tables as needed and use them on visual objects.
There are some sample reports of various industries in the learn center of the service, you can choose the right report to download to your desktop for research.
Here are some references that may be helpful.
Calculating Weekly Sales w/DAX In Power BI
Power BI Calculate Cumulative Total by Week Within Quarter
Get Current Month Sales Report using Power BI Measure
Best Regards,
Community Support Team_GaoIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi Intermountain ，
From your description, you may need a calendar table, an employee information table, a table describing production information, then create relationships using the date table with the employee information table linked to the production information table, and finally create metrics, calculated columns or calculated tables as needed and use them on visual objects.
There are some sample reports of various industries in the learn center of the service, you can choose the right report to download to your desktop for research.
Here are some references that may be helpful.
Calculating Weekly Sales w/DAX In Power BI
Power BI Calculate Cumulative Total by Week Within Quarter
Get Current Month Sales Report using Power BI Measure
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data