Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a DAX Measure as shown below
SPLY INVoiced =
CALCULATE(
[Invoice Line Total],SAMEPERIODLASTYEAR('Date'[Date]))
The goal is to filter the 1 yr that is added so that all the line graphs end up in May 2023 rather than May 2024.
How do I change the DAX Measure to reflect that?
Solved! Go to Solution.
After doing some extensive research, this is my answer
SPLY Sales Amount =
IF(MONTH(TODAY()) >= SELECTEDVALUE('Date'[Month Num]) && YEAR(TODAY()) = SELECTEDVALUE('Date'[Year]),
CALCULATE(Sum('Sales'[Price]),SAMEPERIODLASTYEAR('Date'[Date])
),Blank())
After doing some extensive research, this is my answer
SPLY Sales Amount =
IF(MONTH(TODAY()) >= SELECTEDVALUE('Date'[Month Num]) && YEAR(TODAY()) = SELECTEDVALUE('Date'[Year]),
CALCULATE(Sum('Sales'[Price]),SAMEPERIODLASTYEAR('Date'[Date])
),Blank())
Hi @Datagulf , You can use the below formula :-
Last Year Invoice Line Total =
VAR MaxDate = MAX('Date'[Date])
VAR LastYearEndDate = EOMONTH(MAX('Date'[Date]), -12)
VAR LastYearStartDate = EOMONTH(LastYearEndDate, -11)
RETURN
CALCULATE( [Invoice Line Total], FILTER( ALL('Date'), 'Date'[Date] >= LastYearStartDate && 'Date'[Date] <= LastYearEndDate ) )
Please do gives a thumbs up if you find it helpfull
it says there is an error.
i have used a different method and it works fine now.. Thanks though
Hi @Datagulf You can try this measure
SPLY INVoiced =
VAR MaxDate = Month(Today())
VAR MinDate = Month(Today()) - 12
RETURN
CALCULATE(
[Invoice Line Total],
Filter(Date,
'Date'[Date] >= MinDate && 'Date'[Date] >= MaxDate
))
If it solves your query, Please accept it as a solution. so that someone will get help from this.
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |