Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I've got a report where I have transaction data in dollars, each line shows a transaction, the time and the dollar amount...and I'm using the report to instead show a count of the transactions by changing the way the values are calculated with the values dropdown in report.
This is great for daily...but I'm trying to get an average count over a month range...
I'd imagine I have to make a new column that will count the transactions per date and then I can average it?
Advice please 🙂
Hi @unclejemima,
Sorry, but I'm not quite understand your requirement. Could you please share us more detailed information about your requirement if possible? Like your source table structure and some sample data. So that we can make some test about your issue and provide a proper solution. Also please attach your desired result, it'll give us the right direction.
Thansk,
Xi Jin.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |