Forum Discussion

Kumarun's avatar
Kumarun
Icon for Helper I rankHelper I
3 years ago

Need All the data in table

Hai Team,

Filed record

Approved records

Table

 


I have two dates one is the Application filed date, and the Application approved date.

November month filed records are 6 and approved records are 8.
So, by using the date table I have selected November month its showing the correct records in the matrix visual. I am getting only 6 records in tabular visual it is taking only filed data, not the approved data.

I need to be filed and approved records combined in single tabular visual means 6+8=14.
Help me 
Thanks in Advance

Need Help

2 Replies

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Kumarun ,

     

    You can create two measures to get the results of two tables, and new a measure to sum these results. Then put other columns and these measures in the same table visual.

     

    Hope this help you.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.