Daily Phone Call Report
Hello community, this is my very first question about PowerBI. I'm trying to create a report that shows how many call are being made by a SDR day by day to make a comparative clustered column chart. I'm using 3 columns from my phonecall table which comes from a Direct Query to our CRM (Dataverse) so i know there are some inherit limits with that. For my x-axis i have "Actual End" Column. For my y-axis i have "count of statuscodename" I tried distinct and still not working. And the legend is the "Owner" My question is, what I'm missing and why my graph is displaying multiple bars. Thank for all and have a great day!
Formula - Circular dependency - Cumulative Sum?
Hello! (Not sure if it's okay to post it here but I really need some help) I need to make some measures where they are dependent to each other. But PowerBI says that I have a circular dependency So I tried to find a way to make it not dependent but I can't seem to get it. Here's the sample data: 1st month of the beginning cash is a fixed value (I'm good with this, planning to have a parameter?) 1st month of the ending cash is current beginning + cash flow. 2nd month of beginning cash is last month's ending cash. 2nd month of ending cash is current beginning +cash flow. And so on and so forth. Beginning and Ending Cash are dependent. I'm thinking of having another measure, True Cash, that will compute for the cumulative cash total. But I have no idea also on this part. Also, my Cash Flow is a calculated measure. Any help is appreciated. Thank you!
