Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi to all,
I am having an issue with time intelligence, which realy drives me crazy..
Iam not to able to have the currunt period + YTD. Please note the following:
- The wanted results is to show the month and month YTD (e.g. June + June YTD).
- i have used the following DAX to show the
it's not clear
i really really need your support on this subject.
regards,
Thanks Devanshi,
how can I link it to the filter button (Currunt Month / YTD)? because i'm only seeying DAX YTD ?
Monthytd = TOTALYTD(SUM([Sale column name]),[Date])
YTD =
VAR selected = SELECTEDVALUE(MONTH[Date])
RETURN
IF(selected , selected && Monthytd, [Sale column name] )
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
11 | |
9 | |
8 | |
8 |