Environment Any PAN-OS. Palo Alto Firewall. URL Filtering. Resolution Many of you are wondering, “How do I test to see if our URL Filtering service is enforcing my organization’s policies for malicious and benign URLs properly?” For benign categories, this is relatively straightforward, you simply visit the website and see if the designed policy is Read More
World Password Day
Did you know that today, May 5th is World Password Day. Weak password can be an opportunity for cyberattackers to gain access to your accounts. In 2020, cybercrime could the world over $1 trillion dollars. Here are some password tips to help continue to protect your identity and your data. Please don’t hesitate to reach out to Read More
Temporarily stop updating – Moving to Another City
I will temporarily stop updating this website for a while. Because I am moving to another city. Thanks.
How to Use HASONEVALUE to Remove Unexpected Sum
Review the table visual, noticing the total for the Target column. Summing the target values together doesn’t make sense because salespeople targets are set for each salesperson based on their sales region assignment(s). A target value should only be shown when a single salesperson is filtered. You will implement a measure now to do just that. Rename Read More
How to DISTINCTCOUNT with FILTERS and ALL
Questions: I needed to do a running DISTINCTCOUNT of of the number of customers (Source No_) from a transaction table (Value Entry) with 2 FILTERS (Document Type = 2 && Sales > 0) That was fairly easy as below; Active Customers = calculate(DISTINCTCOUNT(‘TABLE$Value Entry'[Source No_]), FILTER(T_Date, T_Date[Date] <= max(T_Date[Date])), FILTER(‘TABLE$Value Entry’,and(‘TABLE$Value Entry'[Document Type]=2, ‘TABLE$Value Entry'[Sales Amount Read More
How to Use DATEADD to Generate Comparisons Over a Range of Different Time Frames
DATEADD is a flexible and powerful DAX function. DATEADD takes in a date column, the offset, and the time interval for the offest. The offset is the number of intervals to go forward or back in time. Example Formulas: Rev Previous_Day = CALCULATE(SUM(TransactionData[Revenue]),DATEADD(CalenderDate[Date],-1,DAY) Rev Previous_Month = CALCULATE(SUM(TransactionData[Revenue]),DATEADD(CalenderDate[Date],-1,MONTH)) Rev Previous_Quarter = CALCULATE(SUM(TransactionData[Revenue]),DATEADD(CalenderDate[Date],-1,QUARTER) Rev Previous_Year = CALCULATE(SUM(TransactionData[Revenue]),DATEADD(CalenderDate[Date],-1,YEAR))