Results for: formula Search Results
Family Filter:
10:51
"Hello Friends, Welcome to our latest video on how to convince buyers for your import export business. Your EXIM Einstein, Mr Vaibhav Sharma, has shared five important tips that will help you understand the major points for convincing your buyers.
4 Sep 2019
11
Share Video

2:19
Are you a sales manager in Channel of Distribution? Then watch the video to learn the art of extracting maximum sales following the formula of 1×6×N on a daily basis.
26 Aug 2019
15
Share Video

2:26
The time from conception to a child’s second birthday is the most important 1,000 days of their life, as these initial months are vital developmental periods during which babies’ brains and bodies need the right fuel to grow. Providing infants with the best possible nutrition during these early days is important – whether parents choose to breastfeed, formula-feed or both. If you don’t breastfeed, parents can still feel confident that baby will get the best nutrition. Dr. Christina Valentine and Registered and Licensed Dietitian/Nutritionist, Lucille Beseler discussed with us the ingredients and scientific innovation behind Enfamil, the #1 formula brand recommended by pediatricians.
3 Sep 2019
695
Share Video

3:33
15-Days fully-fledged FREE Trial | FREE Online Support | No Credit Cards needed Book your Online Demonstration today! The survey says that many warehouses do not follow better space optimization techniques that results in around 20% of their warehouse space vacant. During the calculation of warehouse space, there are many points to be considered in terms of upcoming inventory types and sizes, successful space calculation methods, recent trends etc. The space could be able to make affects on cost, efficiency and productivity directly. So, maximizing space utilization is becoming very critical these days than ever before. Our team can help you more to understand about how to build an effective Warehouse Management Process
5 Sep 2019
29
Share Video

6:22
Digestion Support Capsule is a wonderful herbal formulations by Planet Ayurveda. The herbs used in this formula are Amalaki (Emblica officinalis), Haritaki (Terminalia chebula), Babhitaki (Terminalia bellerica), Madhurika (Foeniculum vulgare), Dhanaka (Coriandrum sativum), Jeerak (Cuminum cyminum), and Pippali (Piper longum).
26 Aug 2019
73
Share Video

2:57
Winners India Tour is coming to Nashik on 31st August 2019 for a path-breaking formula for success in business. Mr. Shashikant Khamkar, a successful spiritual business and life coach is coming to uncover the secrets of building a powerful business empire. He's bringing people who have achieved huge success in business after they decided to believe in themselves. "In order to get success, you have to believe in yourself. Unless you believe in yourself, you'll not be able to taste success," says Mr. Shashikant. Mr. Shashikant has helped hundreds of people to succeed in life and aims at helping you succeed too. It is his commitment. Come and attend the seminar that's completely free of cost and discover your path to success. Date: 31st August 2019 Time: 4 PM to 8 PM Venue: Nashik-Pune Road, Near Nasardi Bridge, Near Life Care Hospital, Nashik
27 Aug 2019
34
Share Video

2:57
Winners India Tour is coming to Nashik on 31st August 2019 for a path-breaking formula for success in business. Mr. Shashikant Khamkar, a successful spiritual business and life coach is coming to uncover the secrets of building a powerful business empire. He's bringing people who have achieved huge success in business after they decided to believe in themselves. "In order to get success, you have to believe in yourself. Unless you believe in yourself, you'll not be able to taste success," says Mr. Shashikant. Mr. Shashikant has helped hundreds of people to succeed in life and aims at helping you succeed too. It is his commitment. Come and attend the seminar that's completely free of cost and discover your path to success. Date: 31st August 2019 Time: 4 PM to 8 PM Venue: Nashik-Pune Road, Near Nasardi Bridge, Near Life Care Hospital, Nashik
27 Aug 2019
36
Share Video

2:14
Nutritioncare offers nutrition care gut relief powder, one of the best and simple solutions to get good gut health. Our unique NC Gut Relief 150g Powder is a comprehensive herbal nutritional formula that helps maintain gastrointestinal health. If you want to learn more, then please visit our official website.
28 Aug 2019
8
Share Video

1:07:39
Peter by active faith got out of the boat and walked on water. If you will just walk with jesus He will make you free from sin and Satan, and give you the liberty that is in Christ Jesus. Galatians 3:26-28 For ye are all the children of God by faith in Christ Jesus. For as many of you as have been baptized into Christ have put on Christ. There is neither Jew nor Greek, there is neither bond nor free, there is neither male nor female: for ye are all one in Christ Jesus. Romans 6:3-5 Know ye not, that so many of us as were baptized into Jesus Christ were baptized into his death? Therefore we are buried with him by baptism into death: that like as Christ was raised up from the dead by the glory of the Father, even so we also should walk in newness of life. For if we have been planted together in the likeness of his death, we shall be also in the likeness of his resurrection: The following is a true record of a Baptism which took place in Rome A.D. 100 and was reproduced in TIME magazine, December 5, 1955. "The deacon raised his hand, and Publius Decius stepped through the baptistry door. Standing waist-deep in the pool was Marcus Vasca the woodseller. He was smiling as Publius waded into the pool beside him. ‘Credis?’ he asked. ‘Credo,’ responded Publius. ‘I believe that my salvation comes from Jesus the Christ, Who was crucified under Pontius Pilate. With Him I died that with Him I may have Eternal Life.’ Then he felt strong arms supporting him as he let himself fall backward into the pool, and heard Marcus’ voice in his ear ---- ‘I baptize you in the Name of the Lord Jesus’ ---- as the cold water closed over him." Schaff-herzog Encyclopedia of Religious Knowledge Volume 1, page 435--1966 edition "The New Testament knows only baptism in the name of Jesus... which still occurs even in the second and third centuries" Encyclopaedia of Religion and Ethics Edited by James Hastings Volume 2, page 384--1958 edition under Method of Baptism "The formula used was 'in the name o
4 Sep 2019
49
Share Video

5:00
1. Last MTD order Last MTD = CALCULATE(SUM('MOM Growth'[Orders]),PREVIOUSMONTH('MOM Growth'[Date].[Date])) 2. Cumulative MTD order over YTD when you change the date in total ytd formula, cumultive sum stack till that date Cumulative MTD Order over Year = CALCULATE(TOTALYTD(SUM('MOM Growth'[Orders]),'MOM Growth'[Date],ALL('MOM Growth'),"12/31"),YEAR('MOM Growth'[Date])=2019) 3. Dynamically MTD Order history First Generate no. then create measure, in that measure variable, hasonvalue, if, filter and sumx formula require, filter is very important because you can put all relative criteria in filter table second you have to create another separate measure for sum of sale othwerwise it wil not show you correct count Dynamically MTD order history = //CURRENTDAY VARIABLE PREPARE ON THE BASIS OF FEB AND MAXIMUM 31 DAY CRITERIA, WHEN MONTH END // 31 AND CURRENT MONTH 30 THEN WHEN WE PREVIOUS MONTH ALL DATA THATSWHY BELOW MAX 31 DAY MEASURE CREATED var currentday = IF(OR(DISTINCTCOUNT('MOM Growth'[Date])=30,AND(DISTINCTCOUNT('MOM Growth'[Date])=28,SELECTEDVALUE('MOM Growth'[Date].[MonthNo])=2)),31,DISTINCTCOUNT('MOM Growth'[Date])) var currentmonth = SELECTEDVALUE('MOM Growth'[Date].[MonthNo]) var Currentyear = SELECTEDVALUE('MOM Growth'[Date].[Year]) //IF AND HASONEFORMULA BASICALLY CHANGE THE MONTH NO. AS PER SELECTION. VAR CHANGEONSELECTIONMONTH =IF(HASONEVALUE('Orderday History'[Order History Day]),VALUES('Orderday History'[Order History Day]),BLANK()) var maxmonth_YTD = CALCULATE(MAX('MOM Growth'[Date].[MonthNo])-(CHANGEONSELECTIONMONTH-1),ALL('MOM Growth')) return IF(HASONEVALUE('MOM Growth'[Date].[MonthNo]), SUMX(FILTER(ALL('MOM Growth'),IF(currentmonth=1,'MOM Growth'[Promoter]=SELECTEDVALUE('MOM Growth'[Promoter]) && 'MOM Growth'[Date].[Day]<=currentday && 'MOM Growth'[Date].[MonthNo]=maxmonth_YTD && 'MOM Growth'[Date].[Year]=Currentyear-1,'MOM Growth'[Promoter]=SELECTEDVALUE('MOM Growth'[Promoter]) &&'MOM Growth'[Date].[Day]<=currentday && 'MOM Growth'[Date]
10 Sep 2019
24
Share Video

1:59
1. Last MTD order Last MTD = CALCULATE(SUM('MOM Growth'[Orders]),PREVIOUSMONTH('MOM Growth'[Date].[Date])) 2. Cumulative MTD order over YTD when you change the date in total ytd formula, cumultive sum stack till that date Cumulative MTD Order over Year = CALCULATE(TOTALYTD(SUM('MOM Growth'[Orders]),'MOM Growth'[Date],ALL('MOM Growth'),"12/31"),YEAR('MOM Growth'[Date])=2019) 3. Dynamically MTD Order history First Generate no. then create measure, in that measure variable, hasonvalue, if, filter and sumx formula require, filter is very important because you can put all relative criteria in filter table second you have to create another separate measure for sum of sale othwerwise it wil not show you correct count Dynamically MTD order history = //CURRENTDAY VARIABLE PREPARE ON THE BASIS OF FEB AND MAXIMUM 31 DAY CRITERIA, WHEN MONTH END // 31 AND CURRENT MONTH 30 THEN WHEN WE PREVIOUS MONTH ALL DATA THATSWHY BELOW MAX 31 DAY MEASURE CREATED var currentday = IF(OR(DISTINCTCOUNT('MOM Growth'[Date])=30,AND(DISTINCTCOUNT('MOM Growth'[Date])=28,SELECTEDVALUE('MOM Growth'[Date].[MonthNo])=2)),31,DISTINCTCOUNT('MOM Growth'[Date])) var currentmonth = SELECTEDVALUE('MOM Growth'[Date].[MonthNo]) var Currentyear = SELECTEDVALUE('MOM Growth'[Date].[Year]) //IF AND HASONEFORMULA BASICALLY CHANGE THE MONTH NO. AS PER SELECTION. VAR CHANGEONSELECTIONMONTH =IF(HASONEVALUE('Orderday History'[Order History Day]),VALUES('Orderday History'[Order History Day]),BLANK()) var maxmonth_YTD = CALCULATE(MAX('MOM Growth'[Date].[MonthNo])-(CHANGEONSELECTIONMONTH-1),ALL('MOM Growth')) return IF(HASONEVALUE('MOM Growth'[Date].[MonthNo]), SUMX(FILTER(ALL('MOM Growth'),IF(currentmonth=1,'MOM Growth'[Promoter]=SELECTEDVALUE('MOM Growth'[Promoter]) && 'MOM Growth'[Date].[Day]<=currentday && 'MOM Growth'[Date].[MonthNo]=maxmonth_YTD && 'MOM Growth'[Date].[Year]=Currentyear-1,'MOM Growth'[Promoter]=SELECTEDVALUE('MOM Growth'[Promoter]) &&'MOM Growth'[Date].[Day]<=currentday && 'MOM Growth'[Date
11 Sep 2019
15
Share Video

5:00
TOday we will learn 1. Last MTD comparision with today MTD Value Note: in first step, Don't put table value column in UI or in table. if u do this then table will be showing blank after that u can put it Last Day order = CALCULATE(SUM('MOM Growth'[Orders]),DATEADD('MOM Growth'[Date],-1,DAY)) Last Day MTD Comarision = var lastdaymtd_compare = EOMONTH(SELECTEDVALUE('MOM Growth'[Date]),-1) return IF(DAY(lastdaymtd_compare)=31,CALCULATE(SUM('MOM Growth'[Orders]),DATEADD('MOM Growth'[Date],-31,DAY)), CALCULATE(SUM('MOM Growth'[Orders]),DATEADD('MOM Growth'[Date],-30,DAY))) 2. History Day value as per day selection or Dynamically change value history first create value table on generate series basies formula Dynamically order history = var orderhistory= "-" & IF(HASONEVALUE('Orderday History'[Order History Day]),VALUES('Orderday History'[Order History Day]),BLANK()) return CALCULATE(SUM('MOM Growth'[Orders]),DATEADD('MOM Growth'[Date],orderhistory,DAY)) Cumulative MTD Day order Cumulative MTD Day Order = CALCULATE(SUM('MOM Growth'[Orders]),DATESMTD('MOM Growth'[Date]) ) Weekday and weekend in measure, text in measure Weekday or weekend = IF(AND(WEEKDAY(SELECTEDVALUE('MOM Growth'[Date]),2)>=1,WEEKDAY(SELECTEDVALUE('MOM Growth'[Date]),2)<=5),"Week Day","Weekend")
12 Sep 2019
21
Share Video

Loading...