Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I want create a column that would mark "true" for Max three month else "false"
Date | new column = true or false |
october 2022 | true |
september 2022 | true |
august 2022 | true |
july 2022 | false |
june 2022 | false |
may 2022 | false |
april 2022 | false |
march 2022 | false |
february 2022 | false |
NewColumn := DATEDIFF(YourTable[Date], NOW(), MONTH) <= 3