Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All
Solved! Go to Solution.
Hi @admin11 ,
You could change YEAR(TODAY()) to the value of the slicer,Here can use MAX() ,as follows:
_Month last =
FORMAT (
DATE ( MAX ( 'Date'[YEAR2] ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) ),
"mmm-yyyy")
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @admin11 ,
You could change YEAR(TODAY()) to the value of the slicer,Here can use MAX() ,as follows:
_Month last =
FORMAT (
DATE ( MAX ( 'Date'[YEAR2] ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) ),
"mmm-yyyy")
The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@admin11
Try
Month Last =
FORMAT(
DATE(
YEAR( SELECTEDVALUE(DATE[YEAR])),
MONTH(TODAY())-1,
DAY(TODAY()))
,
"mmm-yyyy"
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
94 | |
89 | |
35 | |
32 |
User | Count |
---|---|
153 | |
101 | |
82 | |
63 | |
52 |