Commentsdernan (47)in hive-102332 • 5 years agoRE: 6 DAX tips for Excel and Power BI usersIt's been some time since you did a DAX article Paula. I have missed these. All the tips provided are great and it is hard to pick a favorite. If people could stick to these tips, it will save…dernan (47)in excel • 5 years agoRE: Excel Superstars you need to be followingThere are a few names on the list I do not recognize Paula, thank you for this resource. I will have to check them out. Are any of them going to join you and offer the learn and earn activities…dernan (47)in advancedfiltercontextindax • 5 years agoRE: DAX - FILTER inside CALCULATERight! I think I got this one now. We need a column name on the left and a value on the right. If these criteria are not filled you must put FILTER inside of CALCULATE.dernan (47)in excel • 5 years agoRE: 5 Reasons Spreadsheet Users should be using Excel 365hi Paula, thanks for sharing the link for the free month of Excel 365. It does not seem to be an affiliate link, how come? you do so much for Microsoft you should at least get commission. I am…dernan (47)in excel • 5 years agoRE: XLOOKUP V's VLOOKUP - 8 Limitations RemovedPaula I was wondering when you were going to inform us about this. I have seen some articles on XLOOKUP on LinkedIn and I am eagerly awaiting the roll out to all Excel 365 subscribers. Any idea…dernan (47)in excel • 5 years agoRE: Calculate 50 & 100-Day Moving Average with DAXHello Paula. I have made my dashboard and I am really pleased with it. I followed this tutorial and the previous tutorial. I worked on them both during the week. But there is no way to upload…dernan (47)in excel • 5 years agoRE: Excel and Coinmarketcap - live cryptocurrency dashboardPaula, there is no way to upload the screen shots in the comments?dernan (47)in excel • 5 years agoRE: Learn and Earn STEEM ActivitiesThis is really fantastic Paula, I hope to spend much to today catching up with loads of these learn and earn activities. Do you have like an index list of them? I know you send out a newsletter…dernan (47)in excel • 5 years agoRE: How to Parse Custom JSON Data using ExcelI have just come back to try this now and I am also getting the same errordernan (47)in excel • 5 years agoRE: Excel 101 – Getting Started with Excel 365Learn and earn activity 3 - I like the new natural language search, but if you want to get to a quick video tutorial, F1 I think is better.dernan (47)in excel • 5 years agoRE: Excel 101 – Getting Started with Excel 365Learn and earn activity 2 - page setup is on the Page layout ribbon. Clipboard commands are found on the home ribbondernan (47)in excel • 6 years agoRE: Easy Excel Solutions: Power Pivot Many to Many RelationshipsAs always Paula this is a great resource, when I started out on powerpivot I always got that 'Relationships may be needed' warning and could never figure it out because it would not let me set up…dernan (47)in excel • 6 years agoRE: Finding Your Way around Power Pivot - An OrientationI started using Powerpivot when it was introduced as an ad in way back in 2010. I am surprised that not more people have been using it. One thing I struggle with, and you will probably get to it…dernan (47)in excel • 6 years agoRE: Excel 101 – Getting Started with Excel 365@theexcelclub you have blown me away with the detail in this post. This is a must-have #execl resource for all new excel user. You have pulled the hat out of the bag with this one. And 7 learn and…dernan (47)in excel • 6 years agoRE: How to Resolve Errors in Excel FormulaI never ran error checking on a full spreadsheet before, thanks for that. I did however resolve errors that were auto detected as they came up. its not something I would leave. Most of the time…dernan (47)in excel • 6 years agoRE: Step by Step - Named Ranges in Excel@theexcelclub you made this nice and easy indeed to earn steem rewards. I have a number of spreadsheets set up using named ranges, but most often I would use Table format and use a column name in a…dernan (47)in excel • 6 years agoRE: How to Reconcile Accounts using Power QueryPaula this is exactly what I was looking for. I thought I would have to use Power Pivot and set up relationships. I haven't worked through the activity yet, but I will do and I will come back to…dernan (47)in excel • 6 years agoRE: The Secret Power of SUMPRODUCT in ExcelWell Paula that was a very challenging activity I must say. I would really encourage others to try it out as working out the formula really made the penny drop on how sumproduct works in terms of…dernan (47)in excel • 6 years agoRE: Related and RelatedTable - DAX for Power Pivot, Power BI and SSAS@theexcelclub thank you for these tutorials. I started using Excel Power tools after reading a few of your articles and it's the best thing ever. although I must say, learning dax is harder than I…dernan (47)in excel • 6 years agoRE: Power BI Custom Visuals - Dial Gaugehi @paulag and great tutorial again. I like to use the tachometer chart, its similar to the gauge chart you have demonstrated.
Comments
RE: 6 DAX tips for Excel and Power BI users
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Excel Superstars you need to be following
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: DAX - FILTER inside CALCULATE
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: 5 Reasons Spreadsheet Users should be using Excel 365
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: XLOOKUP V's VLOOKUP - 8 Limitations Removed
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Calculate 50 & 100-Day Moving Average with DAX
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Excel and Coinmarketcap - live cryptocurrency dashboard
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Learn and Earn STEEM Activities
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: How to Parse Custom JSON Data using Excel
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Excel 101 – Getting Started with Excel 365
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Excel 101 – Getting Started with Excel 365
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Easy Excel Solutions: Power Pivot Many to Many Relationships
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Finding Your Way around Power Pivot - An Orientation
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Excel 101 – Getting Started with Excel 365
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: How to Resolve Errors in Excel Formula
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Step by Step - Named Ranges in Excel
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: How to Reconcile Accounts using Power Query
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: The Secret Power of SUMPRODUCT in Excel
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Related and RelatedTable - DAX for Power Pivot, Power BI and SSAS
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
RE: Power BI Custom Visuals - Dial Gauge
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit