sample csv file

How to Create a Calculate Column for The Same Day of Last Year

You can create a calculated column in Calendar Dimension: SameDayLY= var TodayDate = TODAY() var LastYear = YEAR(TodayDate)-1 var LastMonth = MONTH(TodayDate) var LastDay = DAY(TodayDate) return ‘Calendar'[Date]= DATE(LastYear,LastMonth,LastDay) This solution shoule be good for most of the situation. However, your way returned a true value for “2019-03-01” if Today date was a Leap day Read More

sample csv file

Watch Out Google Group “Moderation”, It May Holds Your Group Emails Without Notifications.

Google Group owners are able to moderate the messages sent to their members to protect them from junk mail. Moderation is not active by default and should be set up as appropriate by the group owner. Owners and managers are generally granted permission to determine which messages should be allowed to be sent to group Read More

sample csv file

How to Build a Power BI Dashboard for Mobile Correctly

4 steps to build Power BI dashboard for Mobile correctly In this article, we will learn how to Optimize a Power BI dashboard for mobile phones.  What is a Power BI dashboard?  How to create a power bi dashboard for mobile phones? What is a Power BI dashboard? A Power BI dashboard is a feature of the Read More

sample csv file

How to Sort a Chart by Different Axis in a Power BI reports

 Important This article is intended for Power BI users who do not have edit permissions to the report or dataset and who only work in the online version of Power BI (the Power BI service). If you are a report designer or administrator or owner, this article may not have all the information you need. Instead, please read Sort by column Read More

sample csv file

How to Set up a URL Redirect for Fixing “404 page not found” Error on Shopify

You should use redirection for that missing URL. From your Shopify admin, go to Online Store > Navigation.Click URL Redirects.Click Add URL redirect.In Redirect from, enter the old URL you want to redirect visitors from. Only broken URLs should be redirected. If the old URL still loads a webpage, the URL redirect won’t work.Note: You can’t Read More