Forum Discussion

anithaMallam's avatar
anithaMallam
Icon for Helper III rankHelper III
5 years ago

need help

Hi All,           I have two tables Payment terms and payment terms master tables which has a common key which ARP Payment Terms Key to make realtionships.      Now i need to see how many Sales A...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

anithaMallam , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

To know the data on one side which is not present , we can use +0 in a measure or this option

anithaMallam's avatar
anithaMallam
Icon for Helper III rankHelper III
5 years ago

Hi Amit,

               Thanks alot for responding.i dont have any sample data as i am importing these tables from sql to power bi for the requirement 

i need to see how many Sales AR Transaction Payment Terms have mapped to the AR Payment Terms Master data by organization 

  • To report the number of unmapped payment terms by organization.

Regards

Anitha