Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have this chart:
Rather than getting the breakdown of each month, how can I display it so everything adds up over time? So the graph should just be an upward slope the closer it gets to today totaling all revenue above...
Solved! Go to Solution.
Hi @Anonymous,
I'd like to suggest you share a pbix file with some sample data, it will be help for test and coding formula.(you can upload to onedrive or google drive and share link here)
You can also take a look at following link about use date function to manually filter records to calculate YTD:
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
Hi @Anonymous,
I'd like to suggest you share a pbix file with some sample data, it will be help for test and coding formula.(you can upload to onedrive or google drive and share link here)
You can also take a look at following link about use date function to manually filter records to calculate YTD:
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
You can use the function TOTALYTD if you want to sum up the revenues from the beginning of the year.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |