automatic report

2 Topics

Automatic calculation
Dear Dax community, hope you are all doing well !! I do have have this question please: we do have contacts to reach out in order to provide specific service in our company, what's requested here is to calculate the number contacts reached at the end of each week. What I'm doing now manually as you see in the below screenshot *2 (up to week 2) at the end of each week , or *3 (up to week 3) , *4(up to week4) ,etc.. until reaching week 12. As you see the value is accumulating by week so now it's 76 as shown in the attached image means this value for 2 weeks only. I'm seeking a way that powerbi can do this calculation automatically without me multiplying each week by the number of finished week 2,3,...12 weeks, and the number should be presented on a Gauge as shown in the below screenshot. any help please urgently, thanks
Solved
tameismael
4 years ago Place DAX Commands and Tips
3.1KViews
1like
8Comments
Calculated column type mismatching in MS List automatic report
Dear All, When I use "Integrate --> Power BI" feature in MS List web App, the type of a calculated column of the report, don't match the ones of the columns used in the formula. I've shared this problem with the MS List community, but they have confirmed it and don't have a solution. They have suggested me to talk about this issue in the Power BI community. Is There someone can help me? Thanks for your Help
Malo
4 years ago Place Desktop
1.3KViews
0likes
5Comments