Posts

Showing posts from August, 2021

Implementing running total from arbitrary dates in DAX - Unplugged #34

  https://www.youtube.com/watch?v=8M8mgfZsTS0

Working below a DAX formula’s granularity

https://www.youtube.com/watch?v=7i03UBWk85Y   Article:  https://www.sqlbi.com/articles/working-below-a-dax-formulas-granularity/

Using ALLEXCEPT vs ALL and VALUES

https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/  

Understanding Calculation Group Precedence

https://www.sqlbi.com/articles/understanding-calculation-group-precedence/  

Calculation Groups: Understanding the Application of Calculation Items

https://www.sqlbi.com/articles/understanding-the-application-of-calculation-items/  

Understanding Calculation Groups

https://www.sqlbi.com/articles/understanding-calculation-groups/  

Column Sub Folders are Better than Measure Sub Folders

https://exceleratorbi.com.au/column-sub-folders-better-than-measure-sub-folders/  

Using Measure Tables in Power BI

  https://exceleratorbi.com.au/measure-tables-in-power-bi/ Create an empty table to be used for Report Measures: _Report Measures = FILTER ( {1}, FALSE ) 

Excelerator / Matt Allington BLOG

  https://exceleratorbi.com.au/blog/

What the heck is a MEASURE TABLE in Power BI???

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

Git experience in Visual Studio

https://docs.microsoft.com/en-us/visualstudio/version-control/git-with-visual-studio?view=vs-2019   Scroll down to the heading The MERGE Editor

Power BI Push Tools

https://www.sqlbi.com/tools/power-bi-push-tools/?utm_source=ssc&utm_medium=pubemail&utm_campaign=Feed%3A+sqlbi_blog+%28SQLBI%29  

Auto-exist on clusters or numbers - Unplugged #22

https://www.youtube.com/watch?v=aRntX-HiiN8

Differences between ALLSELECTED and KEEPFILTERS - Unplugged #33

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

SQLBI Unplugged Videos on YouTube

  https://www.youtube.com/results?search_query=sqlbi+unplugged

Creating custom groups using calculation items - Unplugged #24

  https://www.youtube.com/watch?v=l6si02kf4eU&t=600s Explore how to create custom groups based on a slicer selection in Power BI. For example, create two versions of a measure: one returns the value of the selected items, and another one returns the value of the other items, the ones that are not selected. This and other custom groups can be obtained by manipulating tables in specific calculation items.

Limiting the number of calculation items selected - Unplugged #26

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

Choosing Between Date or Integer

https://www.sqlbi.com/articles/choosing-between-date-or-integer-to-represent-dates-in-power-bi-and-tabular/