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…
Latest Posts
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…
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…
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…
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…
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…
Calculate last or previous value within Power BI
Here is how to calculate last, previous, or values other periods ago in Power BI using DAX measures. It is not always straightforward,…
Create group index column by using DAX
One way to create a group index by using DAX is with the function RANKX. How to do that depends on your dataset…
How to calculate moving average or sum in Power BI
A moving average can help to see data insights that sometimes are a little bit hidden behind seasonality. Here is how to calculate…
How to highlight one line chart series among many in Power BI
If you have multiple line chart series in one chart, then here is how to highlight one series among many in Power BI…
Reader PicksAll posts
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…
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…
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…
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…
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…
Calculate last or previous value within Power BI
Here is how to calculate last, previous, or values other periods ago in Power BI using DAX measures. It is not always straightforward,…
Create group index column by using DAX
One way to create a group index by using DAX is with the function RANKX. How to do that depends on your dataset…
How to calculate moving average or sum in Power BI
A moving average can help to see data insights that sometimes are a little bit hidden behind seasonality. Here is how to calculate…
How to highlight one line chart series among many in Power BI
If you have multiple line chart series in one chart, then here is how to highlight one series among many in Power BI…
