Archive: April 2021

  • My DAX Training Evaluation

    Being fairly new to DAX and having recently completed some DAX training I thought it would be good to briefly share my experiences of the courses I have completed. The two courses I have recently done are: Stairway to DAX and Power BI by Bill Pearson (https://www.sqlservercentral.com/stairways/stairway-to-dax-and-power-bi) Mastering DAX by Marco Russo and Alberto Ferrari (https://www.sqlbi.com/p/mastering-dax-video-course/) Stairway to DAX is…

    » Read more
  • Purple Frog proud to supporting virtual careers fair

    Purple Frog was asked by Shrewsbury Colleges Group if they would like to exhibit at their virtual careers fair. You can find us on virtual stand 23 where you can find out more about what we do, watch some videos and get in touch if you’d like a career with us! To visit our stand online: click here

    » Read more
  • Joe Billingham joins the ever growing Purple Frog team

    Delighted to announce that Joseph (Joe) Billingham has joined the ever growing Purple Frog team. It’s been an interesting start for Joe with a national lockdown being announced on day 2 of his induction but he has settled in fantastically well inducting him over Microsoft Teams as we all worked from home for a time. Now we’re back in the Frog Plex and you can already find him blogging on the Purple Frog Blog. Welcome Joe!

    » Read more
  • Power BI – Enable Load

    In Power BI Power Query there is an option to enable or disable whether a table is loaded into the report. The option ‘Enable load’ can be found by right clicking on the table. Typically, by default, the load is already enabled. There is also an option ‘Include in report refresh’ which lets a user stop a table from refreshing when they refresh the entire report. This maybe useful for static tables or tables that are large which take a…

    » Read more
  • Purple Frog wins Federation of Small Businesses award for digital innovation

    The Purple Frog team were delighted to win the FSB regional award for Digital Innovation. The FSB Celebrating Small Business Awards recognises and celebrates the contribution that businesses make to the UK’s prosperity in terms of innovation, economic drivers and providing the backbone of our communities.

    » Read more
  • Purple Frog signs up to The Good Business Charter

    Purple Frog is delighted to announce it has signed up to the Good Business Charter (GBC), an accreditation that seeks to raise the bar on business practices for employees, tax, the environment, customers and suppliers. Purple Frog is proud to be the first in the data anlytics sector to join the GBC.   It has never been more important for businesses to regain trust and show they care about more than just…

    » Read more
  • How to make your matrix column widths all equal to each other in Power BI using DAX.

    Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. However there is a hack to set the width of your all columns in a matrix so that they are all equal and pixel perfect with DAX! How do you do this I hear you ask? Firstly create a…

    » Read more