Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I've got the following measure
Hi @sam95 ,
Please try:
Start Month 2 = EOMONTH ( MAX ( Treatments[Treatment Date] ), -2 ) + 1 + TIME ( 0, 0, 1 )
End Month 2 = EOMONTH(MAX(Treatments[Treatment Date]), -1) + TIME ( 23, 59, 59 )
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Startmonth 2 = DATE(YEAR(MAX([Date])), MONTH(MAX([Date])) - 1, 1)
Endmonth 2 = EOMONTH(MAX([Date]), -2)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
32 | |
15 | |
14 | |
13 | |
9 |