The Registry of the National Internet Domain of Serbia (RNIDS) has been supporting Cyrillic (.срб) domains for some time, which is a good way to promote Serbian alphabet. The Internet also supports a number of other fonts that you can use freely within the Internet browser, but there are situations when it is necessary to “translate” terms in other languages into one understandable to computer, the so-called Pun Code. To perform this we use the ENCODEURL function.
We are accustomed, when we want to change the type of Excel document, to save it under another name. However, in some recent versions of Excel, this operation is further facilitated. If we enter the Backstage view there we will find the Export menu that allows you to export directly to PDF or change the file type. Also, you can also directly add documents to Power BI.
If you’ve thought that, when you start using PowerPivot, will get rid of array lookup functions you were deadly wrong! Although the concept of a data model does not go hand in hand with the need to use these class of functions, it is sometimes necessary to search the arrays. To do this you will use the LOOKUPVALUE function, and how to use it, in combination with the WEEKDAY function, you will find out in the text that follows.
Slicers are graphic objects that are used as an interactive filters for filtering reports in Pivot and Power Pivot reports. In combination with certain DAX functions they can be used for setting the parameters of the calculation. The following recipe will show you how to do a sales report in which, according to chosen exchange rate, you can see results in different currencies. To test a status of a slicer will be used function HASONEVALUE.
DAX has lots of useful Time Intelligence functions and in this recipe I will pay some attention to these that filter aggregations according to beginning or the end of a period. My friends from ASEE would say: “From the cradle to the grave is the most beautiful is go-go phase”. However, in this recipe I would hold to quantitative results, and DAX helps us to determine them in the easy way (that’s my field of expertise)!