Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi all,
I would like to create a new datetable with only next 3 months which I will use for forecasting figures.
So something like MONTH(TODAY()+1) and +2 and +3 but I have no idea how to do so.
Anyone?
BR,
Jurgen
Solved! Go to Solution.
@jdevalk ,
from today
Calendar(today(), eomonth(today(),3) )
or from month start
Calendar(eomonth(today(),-1)+1 , eomonth(today(),3)
Great, many thanks!
@jdevalk ,
from today
Calendar(today(), eomonth(today(),3) )
or from month start
Calendar(eomonth(today(),-1)+1 , eomonth(today(),3)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.