Data Bear – Power BI Training and Consulting

Call us Today! (020) 8720 6880 | info@databear.com

May 2019

Power BI DAX TOPN function

DAX TOPN This blog post will outline the Power BI DAX TOPN function. The DAX TOPN function is a very practical useful function as we often want to see the top performing products by sales, region or shop. TOPN syntax TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…]) Parameters n_value The first parameter will determine the number […]

Power BI DAX TOPN function Read More »

Power BI DAX: SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD

Power BI DAX: SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD

DAX Time Intelligence Functions In this blog post, we are going to look at three DAX time intelligent functions. These DAX time intelligent functions are PARALLELPERIOD, DATEADD and SAMEPERIODLASTYEAR. I know many of you will say the functions sound very similar and that they have more or less the same functionality. This is not the

Power BI DAX: SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD Read More »