Objective — To have a calendar that has a week start date that can start on any weekday Solution: The solution should use a weekday as a variable and should create a calendar that can have a start date on a given weekday. I have previously given a solution —…

Power bi has released datamarts, a fully managed database service available on power bi service from May 2022. It provides a fully managed Azure SQL database to store and manage your data in relational format. Power BI Datamarts is a premium only feature and requires to have a premium or…

Problem Statement: The user does want to have a date slicer or filter. Also, the user does not want to control the measures based on the last date of the calendar. …

The field parameter feature is released in the May 2022 update of power bi as a preview feature. It allows users to dynamically change the dimensions or measures in a visual. This feature allows developers to create a dynamic report where end-user can change Axis/Row/Column or Measure/values in a visual/page. …

Objective — To have a calendar for any date of the month by just changing only two variables, the end month and end date Solution: The solution should use the month and date as a variable and should create a calendar whose start and end date are based on the…

Objective — To have a calendar for any month by just changing only one variable, end month Solution: The solution should use the month as a variable and should create a calendar whose start and end date are based on the end month provided. The calendar should generate the month…

I needed to have a measure that can work on a selected date or today and give me WTD/MTD/QTD/YTD/Financial YTD/Cumulative/ Rolling etc. I created a period table

Problem Statement: How to perform a ‘split and merge’ on columns to change (a) into (b)?

Power BI provides various time intelligence functions. But as of now, it does not include half-year time intelligence functions. For this, we need to use custom time intelligence. We need to create the following columns in the calendar. Create half years based on the year start date Create Year Half…