Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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] )
User | Count |
---|---|
23 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |