Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
adityavighne
Continued Contributor
Continued Contributor

DAX for MoM% dynamic range

‎05-13-2019 11:39 PM

Hi,

 

I need help for MoM% DAX calculation.

I have date slicer where I want to select the period and it will give me a MoM%

Labels:
Message 1 of 3
624 Views
0
2 REPLIES 2
v-danhe-msft
Microsoft Employee
Microsoft Employee

‎05-14-2019 10:51 PM

Hi @adityavighne ,

Waht could you mean "I have date slicer where I want to select the period and it will give me a MoM%"? For calculating MOM%, you could refer to below link:

https://community.powerbi.com/t5/Desktop/How-to-calculate-MOM/td-p/528731

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 3
613 Views
0
adityavighne
Continued Contributor
Continued Contributor
In response to v-danhe-msft

‎05-14-2019 11:01 PM

this is not helping.

because it compares only particular Month data over Current month data.

 

I want to compare selected days with the same no. of previous period days.

 

e.g. I have selected 15Jan - 14 Feb then it should compare 15dec-14Jan

Message 3 of 3
611 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All