# Tags
**Software** : [[Power Bi]] [[DAX]]
**Functions** used : [[Calculate]] [[SUM]] [[CalculateTable]] [[DATEADD]] [[Isblank]] [[DIVIDE]]
**Date** : 30-March-2025
# Description
- Reporting on Month to month change is a common requirement in this video how to create the month on month measures in DAX within Power BI. In this video i apply the measure to a value investor stock portfolio to see how they have performed month on month.
# Video Link
<iframe width="560" height="315" src="https://www.youtube.com/embed/IVxN6nmAI1M?si=QVX8WFLodzHodxAm" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe>
[GITHUB File Link](https://github.com/jbotes/powerbiTutorials/blob/main/PBI_MOM_Video.pbix)
# DAX
```mquery
MarketValue = CALCULATE(SUM(Fact_Holdings[Value]))
MarketValue (PM) = CALCULATE([MarketValue],
CALCULATETABLE(
DATEADD(Dim_Holding_Date[Date],-1, MONTH)
))
MarketValue MoM =
VAR MVCurrent = [MarketValue]
VAR MVPrevious = [MarketValue (PM)]
VAR Result =
if (
not ISBLANK(MVCurrent) && not ISBLANK(MVPrevious),
MVCurrent - MVPrevious
)
RETURN
Result
MarketValue MOM % = DIVIDE([MarketValue MoM], [MarketValue (PM)],0)
```
## Optional Tags
**Tags** :
**Technique** : [[Date Intelligence]]