How to get monthly and yearly totals using dax

Question

How can I calculate montly yearly totals from the column amount and TRD_datecolumn,Check the data below

Answer 1

 Follow the steps:

Step 1- On the visualization,Select table

Step 2- On the datasource,drag over the Values , the Date column and the Amount column

Step 3- Date-> Quarter Value and Date-> Day value.

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification