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.
I have a date column that has corresponding values. Instead of just seeing all of the dates or just one date. I want to know if there is a way where across the whole column it only takes every month's last date. So for example If my data has September 1 - December 31st I only want to see the last dates in one table for those months.
Solved! Go to Solution.
Hi @ADCOPBI ,
Based on your description, you can create a measure as follows.
Measure =
var x1=ENDOFMONTH('Table'[Date])
return
IF(MAX('Table'[Date])=x1,1,0)
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ADCOPBI ,
Based on your description, you can create a measure as follows.
Measure =
var x1=ENDOFMONTH('Table'[Date])
return
IF(MAX('Table'[Date])=x1,1,0)
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes. Add a transformation step in Power Query using the Date.EndOfMonth function
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |