The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
Below is a list of customers with the corresponding cities that they have been to over two months.
I need a dax formula that would help me plot a graph indicating number of times customers moved in a month and a trend to show how the movements are over the months.
Sample output
Thanks.
Hi @DeeA please explain with example your logic of calculation. thank you
Is your wanted number, simple number of Cities per month?
Proud to be a Super User!
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |