Calculate weighted average in Excel PivotTable in 2 ways
Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX. It is not so simple as…
Last available column value in Power BI
Here is how to detect the last available column value in Power BI in almost any situation. The main problem is columns with…
Control Power BI DAX measures with a slicer
It is easy to control Power BI DAX measures with a slicer and turn them on or off for visualizations or other purposes.…
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…
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…
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…
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…
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…
