Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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] )
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |