Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good afternoon,
Can someone tell me why this is not working?
Solved! Go to Solution.
This is because lastdate returns the current row, you will need to add All(table) as the context:
Column =
var Lastdate_= CALCULATE(LASTDATE('Casino Project Feb 2020'[Date]),ALL('Casino Project Feb 2020'))
Return
IF(YEAR( 'Casino Project Feb 2020'[Date] ) = YEAR (Lastdate_)
&& MONTH( 'Casino Project Feb 2020'[Date]) = MONTH (Lastdate_),
"Yes","No")
Best regards
Paul Zheng
@sschmidt , try using this measure for a try:
VAR SelectedYear = YEAR(SELECTEDVALUE(Casino Project Feb 2020'[Date] ))
VAR SelectedMonth = YEAR(SELECTEDVALUE(Casino Project Feb 2020'[Date] ))
VAR LatestDate = MAX('Casino Project Feb 2020'[Date])
VAR LatestYear = YEAR(LatestDate)
VAR LatestMonth = MONTH(LatestDate)
RETURN IF(SelectedYear = LatestYear && SelectedMonth = LatestMonth, "Yes", "No")
if this Solution works for you, kindly kudo and mark as solution to enable others benefit from it.
@ahmedoye, In the second line, do you mean:
VAR SelectedMonth = MONTH(SELECTEDVALUE(Casino Project Feb 2020'[Date] ))
I changed it to Month and now I am getting all "no"'s so it still isn't doing it correctly.... Do you have any other thoughts? Thank you so much for looking at this.
This is because lastdate returns the current row, you will need to add All(table) as the context:
Column =
var Lastdate_= CALCULATE(LASTDATE('Casino Project Feb 2020'[Date]),ALL('Casino Project Feb 2020'))
Return
IF(YEAR( 'Casino Project Feb 2020'[Date] ) = YEAR (Lastdate_)
&& MONTH( 'Casino Project Feb 2020'[Date]) = MONTH (Lastdate_),
"Yes","No")
Best regards
Paul Zheng
@sschmidt , I figure you are doing this inside a Calculated Column. Edit your Initial DAX to look like this:
In the second line, do you mean:
VAR SelectedMonth = MONTH(SELECTEDVALUE(Casino Project Feb 2020'[Date] ))
I changed it to Month and now I am getting all "no"'s so it still isn't doing it correctly....
Also, the calculated column is returning "yes" for all rows even when it should be "no"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |