DATEDIFF returns the count of interval boundaries crossed between two dates. Syntax DAXCopy Parameters Term Definition start_date A scalar datetime value. end_date A scalar datetime value Return value. interval The interval to use when comparing dates. The value can be one of the following: – SECOND– MINUTE– HOUR– DAY– WEEK– MONTH– QUARTER– YEAR Below, see Read More
What is Data Management?
Data Management enables consistent accessibility, delivery, governance, and security of data to meet an organization’s requirements using tools including master data management, data virtualization, data catalog, and self-service data preparation and wrangling. With an effective data management solution, organizations can unify all of their data intelligently for better access, trust, and control. This is critical to a business’s success because Read More
How to Use “Play Axis” to Show Line Graph Data Over Time Dynamically
There is a financial value plotted on a line graph over time from 2015 to 2019. The Date column is the First of the Month. If you want to use the play axis to do something to show this data dynamically, but is it possible to only have the data appear as the play axis Read More
How to Add a New Table by Using DISTINCT with Multiple Columns
The SELECTCOLUMNS function simply takes some column/columns from another table and create a new table from them. For example, you can take only one column, Revenue, The syntax of SELECTCOLUMNS is simple: Smaller table = SELECTCOLUMNS(Table1;”This day revenue”;[Revenue]) It is the new table name, column name in the new table, column name in the original Read More
How to Fix “Begins with”, “Ends With”, “Contains” Missing in Power Query Filter
If you use PowerQuery (if you don’t learn as quickly as possible), you may notice that in the filter, some of the options you want to use seem to be missing. So why is ‘ Begins with, Ends With, Contains ‘ missing from some PowerQuery filters? In the example below I want to remove any Read More
How to Use “IF”, “ELSEIF”, “ELSE” and “IF NOT” in Excel VBA
VBA If Statement Ref: https://www.automateexcel.com/vba/else-if-statement