Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowHi 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] )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
24 | |
15 | |
13 | |
12 | |
8 |
User | Count |
---|---|
30 | |
22 | |
15 | |
14 | |
14 |