Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have to calculate the sum of the amount of the transaction table which has columns of distinct phones, dates and amounts. These numbers are also included in the Users table which has columns for unique phone, date and is_mobile. Is_mobile may have 0 or 1 value.
for a better understanding of my question, I am mentioning the MySQL query
Select count(phone) from transaction where date(dateCreated)>='2022-10-10' and date(dateCreated)<='2022-10-31' and phone IN(Select phone from users where is_mobile=0)
= List.Sum(TableName[amounts])
--Nate