Forum Discussion

htaunay's avatar
htaunay
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Switch X Axis column through a slicer filter

Hi PowerBI experts,   I am currently working with a dataset where each line represents information of a specific hour, and would like to plot such data grouped by days, weeks or months, given the u...
mws5872's avatar
mws5872
Icon for Helper II rankHelper II
8 years ago

so, almost there I have everything working except quarters. Does anyone know the proper way to use the M(Power Query Lanagugage) to do something like this equivilant in excel/PBI Measures ? 

 

Quarter 

DateFormat = year('Quarter Dates'[DateValue])&"-Q"&ROUNDUP(MONTH('Quarter Dates'[DateValue])/3,0)

 

Month

Dateformat =year('Quarter Dates'[DateValue])&"-"&MONTH('month Dates'[DateValue])

 

I have not been able to find this out yet.

 

Seward12533's avatar
Seward12533
Icon for Solution Sage rankSolution Sage
8 years ago

Date.QuarterOfYear([Registration Date]), Int64.Type)