Saving data into an RDS file is one of my favorite ways to store data, but what if it is necessary to load and combine multiple R RDS files at once? Here is how to do that fast and easily.
Month: June 2021
Substitute multiple values by using DAX in Power BI
Sometimes it is necessary to replace multiple values at once using DAX, and the first thing that might come to mind is function SUBSTITUTE. Maybe because of Excel background but in that case, the solution is not straightforward.
Get the first and the last date of the week with DAX, Power BI
Sometimes it is necessary to get the first and the last date of the week with DAX to create additional information in the tooltip, filter only full week periods, use weeks for continuous chart axis, etc.
Get data from same week last year in Power BI
Here is how to get data from the same week last year in Power BI using DAX measure. I recommend using ISO week and year numbering to get an equal number of days each week and distinguish each year. Sometimes, when you have an unequal number of weeks in years, it might not be easy,… Continue reading Get data from same week last year in Power BI
One of the easiest ways how to generate random numbers in Power Query
If you know how to generate data in Power Query, it might be very useful to create data sets for reproducible examples. Here is one of the easiest methods how to generate random numbers in Power Query. You can combine with generated dates, time intervals, or other data that you can create with list functions.
How to calculate ISO week number and ISO year in DAX
ISO week number and ISO year calculation in DAX might be the best solution if you’re using the Power BI calculated table. They will give you the dimension of weeks with the same number of days and work for multiple years.
How to calculate ISO year in Power Query
ISO year in Power Query is necessary if you have multiple years and want to group data using ISO week number. Some of the dates at the end or beginning of the year might belong to another year.
How to calculate ISO week number and ISO year in Excel
Excel is one of the most popular tools to work with data with more than 400 different functions. Some of them are great to calculate ISO week number in Excel, but ISO year is not so easy.