Forum Discussion
Cumulative Using Summarized Data by x-axis visualizations
Hello everyone, I've the follow table with summarized data, but it's working fine with a table, but I want to show the column Open_Tickets by Calendar in x-axis visualization, this is possible? ...
HugoJesus
Do you still need the OPEN_TICKETS column? If not, change the code after the RETURN as below and try.
ADDCOLUMNS(
TempTable,
"Cummulative",
SUMX( FILTER(TempTable, Date_Link[Calendar] <= EARLIER(Date_Link[Calendar])), [Daily_Open_Tickets])
)
You may share a PBIX file with sample data or an excel sample file to test the same.
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
-------------------------------------------------
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
But the code you have sent is the same.