The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello guys, I'm pretty new to PBI and I have a Previous month measure that doesn't work for january
MoM% =
IF(
ISFILTERED('Requête2'[DATE VOL]),
ERROR("ERREUR"),
VAR __PREV_MONTH =
CALCULATE(
[Nombre bookings],
DATEADD('Requête2'[DATE VOL].[Date], -1, MONTH)
)
RETURN
DIVIDE([Nombre bookings] - __PREV_MONTH, __PREV_MONTH)
)
Any help is welcome 🙂
Best regards
Above measure working fine for me. Try this measure on separate data.
Are there any filters applied ??
How many times january is appearing in your data and for which january its not showing.
please provide the sample data like whats happening right now versus what you want.
Hello, I can't share my data due to organizational policy but I'll provide screenshots
Year Y
Year Y+1
As you can see, Year Y MoM% should show no value as there is no value for precedent year, and year Y+1 should show the difference between December Y and January Y+1
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |