Forum Discussion
Group invoice date
The primary data from a sales report consists of the following: customer name, invoice date, item description, item ID, and additional pertinent information. I need to add the annual and quarterly sa...
Hi dr_anas ,
Please try to create new column with below dax formula:
Year = YEAR([Invoice Date]) Quarter = "Q"&QUARTER([Invoice Date])
Add a matrix visual with fields:
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.