15th April 2020 Power Query – Replace Values for Whole Table Today’s challenge was to replace the values on all the columns in the query when I know the columns will change so I don’t want to name them. Categories Power Query/M/Power BI
9th April 2020 Power Apps – Build a Responsive App – Adding Dynamic Containers In this post we will use dynamic containers to arrange out content so it moves to the planned location at the different screen sizes. We will need to calculate the screen size and then use it to position and size the containers. This post assumes you’ve done everything in the first 2 posts. Calculate Screen Size In order to make... Categories PowerApps
8th April 2020 Power Apps – Build a Responsive App – Initial Setup A responsive app resizes the app based on the browser window and moves parts of the app to make the app work in different screen sizes. The most common sizes to handle are monitor, tablet and mobile phone. Create the Responsive App In the video and for my example I design the app based on a the larger size and... Categories PowerApps
8th April 2020 Power Apps – Build a Responsive App – Planning Before you start a responsive app you need to plan where each element will be on the screen at the different screen sizes. Planning is vital. Categories PowerApps
3rd April 2020 Power BI – COALESCE Function to Remove Blanks This post walks through a simple use of the coalesce function to prevent a measure returning Blank. This function was introduced to Power BI in March 2020. Categories Power BI