CALENDARAUTO
Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is calculated automatically based on data in the model.
Archive
CALENDAR
Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.
Convert Row Data Into Columns with Modulo
This step by step guide will walk through a method of converting row data into columns with a Modulo column. A relatively common issue when building Power BI models is when the input data is formatted in rows versus columns. This is because Power BI… Read More »Convert Row Data Into Columns with Modulo
Create a Power BI Date Slicer Drop-down
One of the most common slicers used in Power BI is a date slicer drop-down, allowing users to filter or slice large data sets by year or month. This is relatively easy to accomplish if the Power BI model only has one data feed but… Read More »Create a Power BI Date Slicer Drop-down
- « Previous
- 1
- …
- 98
- 99
- 100