<html> <p> <br/></p> <table><tbody><tr><td><table><tbody><tr><td><table><tbody><tr><td>We have 3 videos for you this week covering different aspects and skill levels of Excel, Power Query, and DAX. One of which is the solution to last week's learn and earn activity. I hope you enjoy reading or watching this week's content and taking part in the learn and earn activity.<a href="https://theexcelclub.com/dax-and-or-in-or-syntax-which-one/"><img src="https://mcusercontent.com/80956d362d27c2a6d9ab7374a/images/47cd62c6-bb00-4b40-b497-fa48e0f65f27.png" alt=""/></a><a href="https://theexcelclub.com/dax-and-or-in-or-syntax-which-one/"><strong>DAX AND OR IN or syntax(&& ||) – Which one?</strong></a><br/>Article & Video<br/>Last week you learned how to create a conditional statement in DAX using AND, OR, IN and the syntax && and ||. At the end of the article, you were given a problem to solve. How did you get on? <strong>We have now updated the article by adding the solution video. You will find it at the end of the article. </strong>If you missed last week's article and activity, now is a great time to catch up.</td></tr></tbody></table></td></tr></tbody></table></td></tr><tr><td><table><tbody><tr><td><table><tbody><tr><td><strong>VIDEO - Power Query</strong><br/><br/><a href="https://youtu.be/POAfIIzx33c">How to Append tables in Power Query for Excel and Power BI</a><br/> When you are working with data, less is often more. One way of reducing the number of tables you have is to append the tables or sit one on top of the other. In this video, you will learn how to append tables using Power Query. #powerquery can be found in both #excel and #powerbi and this method works in both.</td></tr></tbody></table></td></tr></tbody></table><table><tbody><tr><td><table><tbody><tr><td><strong>VIDEO - Excel</strong><br/><br/><a href="https://youtu.be/xJzSgh1fQVU">How to create and understand Logical tests and IF statement in Excel</a><br/> Excel is a great tool for carrying out logical tests and IF statement type calculations. A logical test will test to see if an expression or a formula returns a true or false result. for example does A=B. An IF statement will allow you to replace the true or false results with a result of your choice. IF statement is a must-have Excel skill</td></tr></tbody></table></td></tr></tbody></table><table><tbody><tr><td><table><tbody><tr><td><strong>Learn and Earn Activities</strong><br/><br/>Here at The Excel Club we offer something truly unique. A chance to earn tokens while you learn. Last week we published a DAX learn and earn activity to add to our library.<br/><strong> </strong><a href="https://theexcelclub.com/learn-and-earn-steem-activities/"><strong> You can find out more about our learn and earn activities here</strong></a><strong>. </strong></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table> <p> <br/> <br/></p> </html>
| author | theexcelclub |
|---|---|
| permlink | the-excel-club-newsletter |
| category | hive-102332 |
| json_metadata | {"tags":["excel","powerbi","powerquery","tutorials","steem"],"image":["https://mcusercontent.com/80956d362d27c2a6d9ab7374a/images/47cd62c6-bb00-4b40-b497-fa48e0f65f27.png"],"links":["https://theexcelclub.com/dax-and-or-in-or-syntax-which-one/","https://youtu.be/POAfIIzx33c","https://youtu.be/xJzSgh1fQVU","https://theexcelclub.com/learn-and-earn-steem-activities/"],"app":"steemit/0.2","format":"html"} |
| created | 2020-02-12 12:26:27 |
| last_update | 2020-02-12 12:26:27 |
| depth | 0 |
| children | 3 |
| last_payout | 2020-02-19 12:26:27 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 1.318 HBD |
| curator_payout_value | 1.178 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 2,953 |
| author_reputation | 49,417,421,433,400 |
| root_title | "The Excel Club Newsletter" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 95,366,812 |
| net_rshares | 9,224,486,000,739 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| mammasitta | 0 | 542,427,814 | 0.1% | ||
| gidlark | 0 | 4,316,958,784 | 1.75% | ||
| alinalazareva | 0 | 834,872,442 | 14% | ||
| anarcist69 | 0 | 5,297,064,408 | 25% | ||
| anarcho-andrei | 0 | 2,038,866,633 | 7.5% | ||
| mattclarke | 0 | 516,839,192,418 | 25% | ||
| abh12345 | 0 | 271,009,922,116 | 20% | ||
| boxcarblue | 0 | 502,442,729,152 | 100% | ||
| mangos | 0 | 714,756,943,918 | 18% | ||
| elviento | 0 | 12,080,833,986 | 11.32% | ||
| ayusor | 0 | 2,436,101,617 | 100% | ||
| isaria | 0 | 86,820,528,770 | 10% | ||
| maxer27 | 0 | 105,217,216,693 | 35% | ||
| derosnec | 0 | 2,869,372,747 | 12.5% | ||
| paulag | 0 | 1,080,123,615,767 | 100% | ||
| spectrumecons | 0 | 812,996,552,589 | 18% | ||
| jayna | 0 | 26,488,136,067 | 10% | ||
| guchtere | 0 | 1,238,924,239 | 12.5% | ||
| edkarnie | 0 | 168,023,817,333 | 40% | ||
| dernan | 0 | 821,865,658 | 100% | ||
| yoogyart | 0 | 20,413,091,370 | 49% | ||
| redrica | 0 | 7,680,451,747 | 5.5% | ||
| uow | 0 | 271,812,813 | 56% | ||
| trevorpetrie | 0 | 7,495,934,598 | 25% | ||
| infamousit | 0 | 4,127,760,035 | 25% | ||
| jlsplatts | 0 | 4,370,361,004 | 1% | ||
| meno | 0 | 177,311,281,974 | 12.5% | ||
| socent | 0 | 1,447,846,637 | 15% | ||
| imisstheoldkanye | 0 | 3,024,601,537 | 1% | ||
| eonwarped | 0 | 206,414,884,076 | 9% | ||
| wolfnworbeikood | 0 | 6,443,297,175 | 13% | ||
| bluefinstudios | 0 | 593,532,080 | 1.25% | ||
| seanlloyd | 0 | 1,829,790,520 | 8% | ||
| jeffandhisguitar | 0 | 16,045,658,126 | 50% | ||
| pechichemena | 0 | 9,559,821,226 | 5% | ||
| mytechtrail | 0 | 39,207,352,878 | 20% | ||
| helpie | 0 | 373,405,854,212 | 25% | ||
| markaustin | 0 | 790,938,519 | 5% | ||
| luisferchav | 0 | 1,398,638,380 | 12.5% | ||
| soulturtle | 0 | 620,695,242 | 5% | ||
| mountainjewel | 0 | 1,285,778,152 | 0.5% | ||
| slacktmusic | 0 | 1,659,333,306 | 12.5% | ||
| znnuksfe | 0 | 3,398,941,357,790 | 50% | ||
| fragmentarion | 0 | 43,649,952,815 | 100% | ||
| portugalcoin | 0 | 34,535,291,855 | 20% | ||
| warpedpoetic | 0 | 5,518,068,927 | 25% | ||
| hazem91 | 0 | 1,995,852,176 | 2.5% | ||
| mamun123456 | 0 | 23,322,010,371 | 25% | ||
| nanobot | 0 | 0 | 0.1% | ||
| zipporah | 0 | 8,551,495,656 | 5% | ||
| spawnband | 0 | 722,316,136 | 5% | ||
| doomsdaychassis | 0 | 15,864,040,155 | 25% | ||
| davenavarro | 0 | 2,145,508,978 | 100% | ||
| big-m | 0 | 837,213,241 | 12.5% | ||
| elemental010 | 0 | 2,687,402,930 | 100% | ||
| veckinon | 0 | 710,222,919 | 12.5% | ||
| javicuesta | 0 | 661,344,264 | 25% | ||
| bembelmaniac | 0 | 9,485,907,985 | 50% | ||
| musicvoter | 0 | 11,112,554,702 | 2% | ||
| kbr | 0 | 586,043,361 | 6.25% | ||
| free-reign | 0 | 2,112,786,581 | 3.75% | ||
| shookriya | 0 | 649,617,270 | 5.55% | ||
| winkandwoo | 0 | 6,185,525,804 | 75% | ||
| musicvoter2 | 0 | 28,296,535,162 | 3% | ||
| frejafri | 0 | 941,495,636 | 2.5% | ||
| kantos | 0 | 605,228,059 | 12.5% | ||
| michael2011 | 0 | 539,124,515 | 100% | ||
| ashikstd | 0 | 4,634,871,437 | 12.5% | ||
| blewitt | 0 | 44,056,709,192 | 1.75% | ||
| cmplxty | 0 | 31,860,845,396 | 100% | ||
| bflanagin | 0 | 11,770,727,022 | 12.5% | ||
| lillywilton | 0 | 825,406,789 | 20% | ||
| dalz | 0 | 55,564,879,195 | 30% | ||
| zainenn | 0 | 15,405,099,381 | 12.5% | ||
| p4ragon | 0 | 3,849,557,027 | 50% | ||
| oakshieldholding | 0 | 1,410,249,672 | 50% | ||
| laissez-faire | 0 | 78,018,383 | 100% | ||
| esthersanchez | 0 | 652,315,396 | 20% | ||
| circa | 0 | 45,694,310,866 | 10% | ||
| limka | 0 | 70,981,969 | 100% | ||
| scholaris | 0 | 58,953,947,455 | 25% | ||
| personalstories | 0 | 545,194,292 | 100% | ||
| ssiena | 0 | 3,850,848,991 | 100% | ||
| jdkennedy | 0 | 44,707,476,676 | 100% | ||
| babytarazkp | 0 | 7,171,243,804 | 100% | ||
| abh12345.stem | 0 | 1,166,935,062 | 100% | ||
| weinweibgesang | 0 | 1,187,881,072 | 17.25% | ||
| johntrash | 0 | 1,123,763,585 | 100% | ||
| joshmania | 0 | 82,466,520,021 | 12.5% | ||
| bilpcoinrecords | 0 | 1,797,072,301 | 2% | ||
| lettersfrommouse | 0 | 539,279,220 | 100% | ||
| stemisaria | 0 | 1,866,596,413 | 100% | ||
| foctard | 0 | 0 | -10% | ||
| womimat | 0 | -8,950,707 | -10% | ||
| bresci | 0 | -7,335,217 | -10% | ||
| fresmi | 0 | 0 | -10% |
Love the challenges! I didn’t see that yet but I know to look periodically for them now! I’ll see if I have time to give it a try!
| author | cmplxty | ||||||
|---|---|---|---|---|---|---|---|
| permlink | re-theexcelclub-2020212t8328165z | ||||||
| category | hive-102332 | ||||||
| json_metadata | {"tags":["excel","powerbi","powerquery","tutorials","steem"],"app":"esteem/2.2.4-mobile","format":"markdown+html","community":"hive-125125"} | ||||||
| created | 2020-02-12 13:32:09 | ||||||
| last_update | 2020-02-12 13:32:09 | ||||||
| depth | 1 | ||||||
| children | 1 | ||||||
| last_payout | 2020-02-19 13:32:09 | ||||||
| cashout_time | 1969-12-31 23:59:59 | ||||||
| total_payout_value | 0.130 HBD | ||||||
| curator_payout_value | 0.135 HBD | ||||||
| pending_payout_value | 0.000 HBD | ||||||
| promoted | 0.000 HBD | ||||||
| body_length | 130 | ||||||
| author_reputation | 782,546,049,086,722 | ||||||
| root_title | "The Excel Club Newsletter" | ||||||
| beneficiaries |
| ||||||
| max_accepted_payout | 1,000,000.000 HBD | ||||||
| percent_hbd | 10,000 | ||||||
| post_id | 95,368,485 | ||||||
| net_rshares | 1,280,289,122,966 | ||||||
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| paulag | 0 | 1,005,760,880,338 | 100% | ||
| theexcelclub | 0 | 274,528,242,628 | 100% |
awesome - I would love to see you take part :-)
| author | paulag |
|---|---|
| permlink | q5lwbr |
| category | hive-102332 |
| json_metadata | {"app":"steemit/0.1"} |
| created | 2020-02-12 20:45:27 |
| last_update | 2020-02-12 20:45:27 |
| depth | 2 |
| children | 0 |
| last_payout | 2020-02-19 20:45:27 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 47 |
| author_reputation | 274,264,287,951,003 |
| root_title | "The Excel Club Newsletter" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 95,385,508 |
| net_rshares | 0 |
Congratulations @theexcelclub! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) : <table><tr><td><img src="https://steemitimages.com/60x70/http://steemitboard.com/@theexcelclub/votes.png?202002191459"></td><td>You distributed more than 23000 upvotes. Your next target is to reach 24000 upvotes.</td></tr> </table> <sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@theexcelclub) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=theexcelclub)_</sub> <sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub> **Do not miss the last post from @steemitboard:** <table><tr><td><a href="https://steemit.com/steemitboard/@steemitboard/valentine-s-day-challenge-give-a-badge-to-your-beloved"><img src="https://steemitimages.com/64x128/http://i.cubeupload.com/LvDzr5.png"></a></td><td><a href="https://steemit.com/steemitboard/@steemitboard/valentine-s-day-challenge-give-a-badge-to-your-beloved">Valentine's day challenge - Give a badge to your beloved!</a></td></tr></table> ###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!
| author | steemitboard |
|---|---|
| permlink | steemitboard-notify-theexcelclub-20200219t152514000z |
| category | hive-102332 |
| json_metadata | {"image":["https://steemitboard.com/img/notify.png"]} |
| created | 2020-02-19 15:25:15 |
| last_update | 2020-02-19 15:25:15 |
| depth | 1 |
| children | 0 |
| last_payout | 2020-02-26 15:25:15 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 1,328 |
| author_reputation | 38,975,615,169,260 |
| root_title | "The Excel Club Newsletter" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 95,615,518 |
| net_rshares | 0 |
hiveblocks