Blogs

Change background color of Item base on values and conditions:

Gallery Property: TemplateFill

The DAX:
If(ThisItem.'U_STU_AcademicStats.DIPLOMA_EARNED'= "Yes" && ThisItem.'Graduation Location' <> "-", Color.LightGreen, ThisItem.'U_STU_AcademicStats.DIPLOMA_EARNED' = "No", Color.LightCoral)

Add this to the "X" property of you element.

(Parent.Width / 2) - (Self.Width / 2)

Saved a ton of time!  Thanks to Micheal Alex!

I am always trying to find these. Easy reference.

Search Operators

I could not find a simple way to do this or at least I couldn't find any instruction in twig docs. 
if is_front == false Did not work.

The below twig did, mind your home page may no be Node 1 like mine is. So change "1" if you need to.

{% if node.id == 1 %}

{% else%}
<div class= "pageheaders"><img src="/images/headerbeach.jpg"/></div>
{% endif %}

OR

{% if node.id != 1 %}
<div class= "pageheaders"><img src="/images/headerbeach.jpg"/></div>

{% else%}

This can be use in a twig template for a view teaser.

<h4 class="title"><a href="{{ url }}" rel="bookmark">{{ node.label }}</a> </h4> 

{{ url }} will create a link to the node associated with the view.

I wanted my script to look at values but ignore the "Null" values for the comparison 

Table.AddColumn(#"Split column by delimiter 1", "PSStudentAddressMatches", each if [PSMailingAddress.1] <> [PSMailingAddress.2] and [PSMailingAddress.2] <> null  then "PS Address Flag"

else if [PSMailingAddress.1] <> [PSMailingAddress.3] and [PSMailingAddress.3] <> null  then "PS Address Flag"

else if [PSMailingAddress.1] <> [PSMailingAddress.4] and [PSMailingAddress.4] <> null then "PS Address Flag"

Table.AddColumn(#"Attendance Hold", "AllHHIDHold", each if Text.Contains([HHIDHomeless], "Homeless") then "OK" else if Text.Contains([ComputerHoldonHHID], "Hold") or  Text.Contains([HotSpotHoldonHHID], "Hold") or  Text.Contains([AddressHold], "Hold") or  Text.Contains([AttendanceHoldonHHID], "Hold") then "Hold" else "OK")

if [StudentsinHHID] = 1 and [Un_Excused_Abs_HHID] > 59 then "AttendanceHold" else if [StudentsinHHID] = 2 and [Un_Excused_Abs_HHID] > 119 then "AttendanceHold" else if [StudentsinHHID] = 3 and [Un_Excused_Abs_HHID] > 179 then "AttendanceHold" else if [StudentsinHHID] = 4 and [Un_Excused_Abs_HHID] > 239 then "AttendanceHold" else if [StudentsinHHID] = 5 and [Un_Excused_Abs_HHID] > 299 then "AttendanceHold" else if [StudentsinHHID] = 6 and [Un_Excused_Abs_HHID] > 359 then "AttendanceHold" else if [StudentsinHHID] = 7 and [Un_Excused_Abs_HHID] > 419 then "AttendanceHold" e

Table.Group(#"Expanded OnbaseData", {"Family_Ident"},

{{"HHIDStudentTotal", each List.Count(List.Distinct([Student_Number])), Int64.Type},

{"ITSRecipient", each List.First([Technology Subsidy Recipient]), type nullable text},

{"StudentsNames", each Text.Combine([LastFirst]," - "), type nullable text},

{"StudentsIDs", each Text.Combine([Student_Number]," - "), type nullable text},

{"ComputerHolds", each Text.Combine(([Unreturned Computer]," - "), type nullable logical},

Don't want to forget how to do this. :)

Body Code:
{'__metadata':
{'type': 'SP.Data.GraduationExportsItem'},
'Title':'Sample',
'FileLeafRef':'PSEnterpriseExport.csv'}