Archive: September 2021

  • Purple Frog is a Digital Leaders 100 Awards Finalist

    We are delighted to being a finalist in the Digital Leaders 100 awards 2021 for our Big Data Innovation – Power BI Sentinel The public vote is now open and will remain so until the 22nd of October. The top three entries per category in the public vote will make it through to the final judging day which is on the 2nd of November. Please vote for us: click here to vote for Power BI Sentinel The top 3 finalists will pitch to the judging…

    » Read more
  • Purple Frog is a CompTIA UK Spotlight Awards finalist

    t’s an absolute delight to announce that Purple Frog Systems Ltd has made it as a finalist in the CompTIA UK Spotlight Awards and have been nominated under the Solution Provider category. We are super grateful for this opportunity and chance to be up for this award. We also have a treat for you that, our very own Alex Whittles, will be speaking at the full-day event CompTIA EMEA Conference from 6-7th October about demystifying emerging…

    » Read more
  • Purple Frog finalist in 3 categories for West Midlands Business Master Awards!

    We are delighted to announce that Purple Frog Systems Ltd has been shortlisted for this year’s West Midlands Business Master Awards! We were excited to have been shortlisted in following categories: International Trade Investment Small Business Winners of the prestigious awards will be announced at TheBusinessDesk.com’s annual dinner at the Macdonald Burlington in Birmingham on the evening of the Thursday 11 November 2021. Read more Sam…

    » Read more
  • Increasing DAX Filter Speed and Efficiency

    To understand how a filter can affect performance, first we need to understand what a filter is. A filter is a temporary table that is created on demand, held in memory, and then used as a reference for the function being filtered. The rows of the temporary filter table are all DISTINCT. This is because for the purposes of filtering, the engine doesn’t care whether there are 1, 2, 3 or 250 occurrences of a value in table, only whether it…

    » Read more
  • Variables in DAX

    Variables can simplify your DAX code, help with debugging and help improve performance. To use variables in your DAX measure you need to declare a variable using the VAR keyword, give the variable a name, and then assign an expression to the variable. You can use multiple variables in a measure but when using variables you must use a RETURN statement to specify the final output to be returned. To show how to make use of variables I’ll go…

    » Read more