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