Thursday, August 31, 2017

Power BI -Create the table with Date Dimension

Reported Date =
ADDCOLUMNS (
  CALENDAR (MIN(Tickets[Reported Date]),MAX(Tickets[Reported Date])),
"Reported Date DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Reported Date Year", YEAR ( [Date] ),
"Reported Date Monthnumber", FORMAT ( [Date], "MM" ),
"Reported Date Year-Month", FORMAT ( [Date], "YYYY-MM" ),
"Reported Date YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"Reported Date MonthNameShort", FORMAT ( [Date], "mmm" ),
"Reported Date MonthNameLong", FORMAT ( [Date], "mmmm" ),
"Reported Date DayOfWeekNumber", WEEKDAY ( [Date] ),
"Reported Date DayOfWeek", FORMAT ( [Date], "dddd" ),
"Reported Date DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Reported Date Quarter", "Q" & FORMAT ( [Date], "Q" ),
"Reported Date Year-Quarter", FORMAT ( [Date], "YYYY" ) & "-Q" & FORMAT ( [Date], "Q" )
)

No comments:

Search This Blog

DAX - Grouping on multiple columns and the count

Please go thorugh the below URL for entire soultion. http://community.powerbi.com/t5/Desktop/DAX-Grouping-on-multiple-columns-and-the-cou...