Skip to content

Instantly share code, notes, and snippets.

@OscarValerock

OscarValerock/00 DAX Gists

Last active February 19, 2025 13:56
Show Gist options
  • Save OscarValerock/911cd58b4d1a019c0f6944b4bfd58842 to your computer and use it in GitHub Desktop.
Save OscarValerock/911cd58b4d1a019c0f6944b4bfd58842 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
00 DAX Gists
// This gist containt useful pieces of DAX code
Raw
01 Power BI Date Table
Date Table =
VAR MinYear = YEAR ( MIN ( 'Table Name'[Table Column] ) )
VAR MaxYear = YEAR ( MAX ( 'Table Name'[Table Column] ) )
RETURN
ADDCOLUMNS (
FILTER(
CALENDARAUTO( ),
AND(
YEAR([Date])>=MinYear,
YEAR([Date])<=MaxYear
)
),
"Year", YEAR ( [Date] ),
"Month Number", MONTH ( [Date] ),
"Year-Month",YEAR([Date])&"-"&if(LEN(MONTH([Date]))=1,"0"&MONTH([Date]),MONTH([Date])),
"YY-MM", FORMAT([Date], "YY-MM"),
"YYMM", FORMAT([Date], "YYMM"),
"Weekday", FORMAT ( [Date], "dddd" ),
"Weekday number", WEEKDAY( [Date] ),
"Year-Quarter",Year([Date])& " Q" & TRUNC ( ( MONTH ( [Date] ) - 1 ) / 3 ) + 1,
"FY-YY", IF(MONTH([Date])>=7, "FY-"&RIGHT(YEAR([Date]) + 1,2) , "FY-"&RIGHT(YEAR([Date]),2)),
"FYYYY",IF(MONTH([Date])>=7, YEAR([Date]) + 1,YEAR([Date])),
"After Today", IF([Date] > TODAY(), TRUE(), FALSE())
)
Raw
02 Rolling Sum
Rolling sum =
VAR MaxDate = MAX('Date Table'[Date])
RETURN
CALCULATE(
[Measure],
'Date Table'[Date] <= MaxDate,
ALL('Date Table')
)
Raw
03 Team cards
01 Team cards =
"
<!DOCTYPE html>
<html>
<head>
<meta charset='UTF-8' />
<style>
"&
[02 CSS Styles]
&"
</style>
</head>
<body>
<div class='cards-holder'>" & CONCATENATEX(
'Team_Members',
"<div class='member-card'>
<div class='image-holder'>
<img class='image' src='"&[00 Image Profile]&"' alt='' />
</div>
<div class='info-section'>
<div class='top-section'>
<h1 class='user-name'>"&'Team_Members'[UserName]&"</h1>
<div class='position'>"&'Team_Members'[UserJobTitle]&"</div>
</div>
<div class='contact-details'>
<hr />
<div class='email'>
<a href='mailto:"&'Team_Members'[UserEmail]&"'>"&'Team_Members'[UserEmail]&"</a>
</div>
<div class='phone'>"&'Team_Members'[UserPhone]&"</div>
<div class='member-quote'>"&'Team_Members'[Quote]&"</div>
<div class='experience-wrapper'>
<span class='years-label'>Experience:</span>
<span class='years-number'>"&'Team_Members'[YearsExperience]&" years</span>
</div>
<div class='expertise-list'>
<span class='expertise-label'>Expertise:</span>
<p>
"&'Team_Members'[Expertise]&"
</p>
</div>
</div>
<hr />
<div class='bottom-section'>
<div class='text-description'>
"&'Team_Members'[UserBio]&"
</div>
<div class='icon'>
<a href='"&'Team_Members'[UserUrl]&"'>
<svg xmlns='http://www.w3.org/2000/svg' width='32' height='32' viewBox='0 0 32 32' fill='none'>
<path
d='M0 16C0 24.8366 7.16344 32 16 32C24.8366 32 32 24.8366 32 16C32 7.16344 24.8366 0 16 0C7.16344 0 0 7.16344 0 16Z'
fill='"&[03 Accent color]&"' />
<path
d='M11.6 24H8.2V13.3H11.6V24ZM9.9 11.8C8.8 11.8 8 11 8 9.9C8 8.8 8.9 8 9.9 8C11 8 11.8 8.8 11.8 9.9C11.8 11 11 11.8 9.9 11.8ZM24 24H20.6V18.2C20.6 16.5 19.9 16 18.9 16C17.9 16 16.9 16.8 16.9 18.3V24H13.5V13.3H16.7V14.8C17 14.1 18.2 13 19.9 13C21.8 13 23.8 14.1 23.8 17.4V24H24Z'
fill='white' />
</svg>
</a>
</div>
</div>
</div>
</div>",
UNICHAR(10),
'Team_Members'[Order]
)
&"</div>
</body>
</html>
"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment