Delay Refresh Until Data is Available

https://blog.crossjoin.co.uk/2020/11/22/delaying-power-bi-dataset-refresh-until-the-source-data-is-ready 

Guy in a Cube - YouTube Videos

 Use DAX to Get Relative Dates: https://www.youtube.com/watch?v=wQ9DohPvx8Q

Making Data Source Parameters Easy: https://www.youtube.com/watch?v=OnaDJkGOmIE

Dynamic Power BI reports using Parameters: https://www.youtube.com/watch?v=iiNDq2VrZPY

Call stored proc, get parameters from Excel.

Populate a Power BI parameter list using a query

https://www.youtube.com/watch?v=7TfV8qTUyfU&t=13s

The How and Why of Power BI Aggregations

https://www.youtube.com/watch?v=EhGF372t0sU

Configure Power BI Aggregations

https://www.youtube.com/watch?v=kytYzjTXUHs

How to Use the Power BI Aggregation Features - Christian Wade

https://www.youtube.com/watch?v=RdHSo43LkQg

Build a Date Picker (uses popup calendar and TREATAS)

https://www.youtube.com/watch?v=zhWtU0DynCk

NEXT LEVEL Power BI Date Picker!

https://www.youtube.com/watch?v=mXi8sMmOOTU

Row-based Time Intelligence

 https://dax.tips/2019/10/09/row-based-time-intelligence/

Guy in a Cube - Home Page

 https://guyinacube.com/

Paul Turley Blog

https://sqlserverbi.blog/ 

Power BI Guidance Documentation

 https://docs.microsoft.com/en-us/power-bi/guidance/

Row-based Time Intelligence

https://dax.tips/2019/10/09/row-based-time-intelligence/ 

Working with Time Periods in Power BI

 https://guyinacube.com/2020/09/16/working-with-time-periods-in-power-bi/

Time Intelligence Functions

 https://docs.microsoft.com/en-us/dax/time-intelligence-functions-dax

Power BI security whitepaper

https://docs.microsoft.com/en-us/power-bi/guidance/whitepaper-powerbi-security 

Add Tooltips

 https://guyinacube.com/2017/06/01/tooltips-tooltips-tooltips-power-bi/

Power BI - How to Set a Default Slicer Value (8:49)

 https://www.youtube.com/watch?v=pCgK-Ze3nhA

Date example - add a DateRange calculated column with this DAX:

DateRange = IF(MONTH(Date[Date]) = MONTH(TODAY()) && YEAR(Date[Date]) = YEAR(TODAY()), "Current Month", MONTH(TODAY()) - MONTH(Date[Date]) & " Months ago")

Select Measure to Render Based on Rows

 

-- create a datatable to populate the rows of a matrix

Metric Slicer =

DATATABLE("Metric", STRING,

{

{ "Units" },

{ "Gross $" }

}

)

-- create a measure to return the correct measure based on the row in a matrix

Loan Metric Selector =

SWITCH(

SELECTEDVALUE(

'Metric Slicer'[Metric]

),

"Units", [Loans Closed Count],

"Gross $", [Total Loan Amount]

)

Total Quantity on Weekdays

 Total Quantity (Weekday) =

CALCULATE(

[Total Quantity],

FILTER(

'Internet Sales',

RELATED('Date'[DayNumberOfWeek]) > 1 &&

RELATED('Date'[DayNumberOfWeek]) < 7))

-- filter on the one side of the relationship

Total Quantity (Weekday) =

CALCULATE(

[Total Quantity],

FILTER(

'Date',

AND('Date'[DayNumberOfWeek] > 1,

'Date'[DayNumberOfWeek] < 7)))

7 Day Moving Average

 Sales 7-Day Moving Average =

VAR StartDate = DATEADD(LASTDATE('Date'[Date]), -6, DAY)

VAR EndDate = LASTDATE('Date'[Date])

 

RETURN

 

AVERAGEX(

DATESBETWEEN(

'Date'[Date],

StartDate,

EndDate),

[Total Sales])

Use CONCATENATEX for Debugging

 3 Month Sales Rolling Average (ConcatenateX) =

VAR EndDate = LASTDATE('Date'[Date])

 

RETURN

CALCULATE(

CONCATENATEX(

VALUES('Date'[MonthNumberOfYear]),

'Date'[MonthNumberOfYear], ", ", 'Date'[MonthNumberOfYear]),

DATESINPERIOD(

'Date'[Date],

EndDate,

-3,

MONTH))

Total Sales All Time (remove blanks)

 Total Sales (All Time) =

IF(

[Total Sales] = BLANK(),

BLANK(),

CALCULATE(

[Total Sales],

ALL('Date'[CalendarYear] ) ) )

3 Month Rolling Average

 3 Month Sales Rolling Average (Values) =

VAR EndDate = LASTDATE('Date'[Date])

 

RETURN

CALCULATE(

CONCATENATEX(

VALUES('Date'[MonthNumberOfYear]),

'Date'[MonthNumberOfYear], ", "), //[Total Sales]),

DATESINPERIOD(

'Date'[Date],

EndDate,

-3,

MONTH))

Rolling 12 Months Profit

 Rolling 12 Months Profit =

VAR StartDate = NEXTDAY(SAMEPERIODLASTYEAR(LASTDATE('Date'[Date])))

VAR EndDate = LASTDATE('Date'[Date])

 

RETURN

CALCULATE(

[Profit],

DATESBETWEEN(

'Date'[Date],

StartDate,

EndDate))

Create a table in DAX

 Metric Selector =

DATATABLE("Metric", STRING,

{

{ "Units" },

{ "Gross $" }

}

)

Populate a Power BI parameter list using a query

https://guyinacube.com/2019/02/20/populate-a-power-bi-parameter-list-using-a-query/

How to override Date Filters in Power BI

https://www.sqlservercentral.com/articles/how-to-override-date-filters-in-power-bi 

Dynamic Power BI Reports using Parameters

https://guyinacube.com/2017/05/24/dynamic-power-bi-reports-using-parameters/

Slicers Introduction

https://hatfullofdata.blog/power-bi-slicer-introduction/ 

Syncing Slicers in Power BI

https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/ 

Power BI – Cascading Slicers

https://hatfullofdata.blog/power-bi-cascading-slicers/ 

Power BI Performance Optimization Tips - Part 1

https://www.mssqltips.com/sqlservertip/6518/power-bi-performance-optimization-tips--part-1 

Power Query – Function to Execute an SQL Procedure

https://hatfullofdata.blog/power-query-function-to-execute-a-procedure/

Run Stored Procedures using parameters in PowerBI

https://cebrusa.com/2019/08/27/run-stored-procedures-using-parameters-in-powerbi/

Power BI Incremental Refresh for SQL Sources

https://www.mssqltips.com/sqlservertip/6476/power-bi-incremental-refresh-for-sql-sources

Analysis Services Live Connect

https://www.youtube.com/watch?v=GPf0YS-Xbyo

Populate a Power BI parameter list using a query

https://www.youtube.com/watch?v=7TfV8qTUyfU

How to Implement a Refresh Date using Power Query

https://guyinacube.com/2020/06/16/how-do-you-get-a-refresh-date-in-your-power-bi-report/

Using Power Query

Limit The Amount Of Data You Work With In Power BI Desktop Using Parameters And Deployment Pipelines

https://blog.crossjoin.co.uk/2020/05/24/limit-the-amount-of-data-you-work-with-in-power-bi-desktop-using-parameters-and-deployment-pipelines/