Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Kumarun
Helper I
Helper I

Need All the data in table

Hai Team,

Filed record

Kumarun_0-1670488204485.png

Approved records

Kumarun_1-1670488245673.png

Table

Kumarun_2-1670488309291.png

 


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

2 REPLIES 2
v-yinliw-msft
Community Support
Community Support

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.

Hi @v-yinliw-msft 

I tried and apply the measure but I'm not getting the correct result.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.