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
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

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

Hi Team,

              Can you please share the calculation logic for calculated column to get 

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

Regards

Anitha.