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: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Jo_Swinnen
Frequent Visitor

Show the data of 5 months ago when a month is selected

‎11-09-2023 04:06 AM

Hi all,

 

If I select november 2023, I want to show the seperate data for april 2023, march 2033, februari 2023, januari 2023, december 2022. 

Is there a dax formula to do this. 

 

Jo_Swinnen_0-1699531546439.png

 

Thanks,

 

Jo 

Labels:
Message 1 of 2
199 Views
0
1 REPLY 1
some_bih
Super User
Super User

‎11-09-2023 05:17 AM

Hi @Jo_Swinnen check link

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Last-5-months-datat-from-a-selected-... 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Message 2 of 2
179 Views
0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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