The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |