Forum Discussion
How do i create a date table ?
I was trying to create a date table for filtering.. And ran across this DAX (below) ... thinking it looked useful. However when I went to create the table and use it.. Didn't seem to work.. e...
we can't calculate our fiscal year from this formula
Quarter = "Q" & ROUNDUP(MONTH(DateKey[Date])/3,0)
My fiscal year start from April & end with March
Date Range = "Datekey = CALENDAR(DATE(2014, 04, 01),DATE(2017, 03, 31))"
Please suggest me.
Thanks
I recommend this post using Power Query from GilbertQ: https://gqbi.wordpress.com/2016/09/07/create-dynamic-periods-for-fiscal-or-calendar-dates-in-power-bi/