Search found 16 matches

by okat
Tue Jun 26, 2018 9:37 am
Forum: Power BI Desktop/Service
Topic: Q&A Error with year 2000
Replies: 0
Views: 805

Q&A Error with year 2000

I've done in Q&A to the following query: " Show Sales by Customers for Sales is greater than 2000" But interestingly enough, the value 2000 is taken as a year. Power bi gives me the options of measurement but only those related to calendar (as if speaking of the year 2000). Any idea wh...
by okat
Sat Apr 07, 2018 12:55 am
Forum: Power Query
Topic: Check all columns
Replies: 3
Views: 799

Check all columns

Every month, I need to perform a repetitive process, for which I need to verify that all the necessary columns are found in the table of origin. For example, in a table I only need the following columns: Employee, payment and discount, but sometimes the discount column does not come in the source ta...
by okat
Sun Feb 11, 2018 9:27 am
Forum: Power Query
Topic: Get start and end date of the current and last semester of the calendar year
Replies: 1
Views: 1210

Get start and end date of the current and last semester of the calendar year

From an X date, I am interested in finding ("M") the starting and ending date of the current semester and the starting and ending date of the previous semester, of the calendar year. For example, today is 10/02/2018. Start current semester = 01/01/2018, date of completion of the current se...
by okat
Fri Dec 15, 2017 1:01 am
Forum: PowerPivot/DAX
Topic: Cumulative per Month
Replies: 1
Views: 1163

Cumulative per Month

Hi Matt. I have a sales file. I need to get the cumulative per month of the difference between the current month and the previous month. To this end I implemented the following measures: 1-Total sales = SUM (sales) 2-Total sales Month Previous = CALCULATE ([total sales]; PREVIOUSMONTH (' Calendar ' ...
by okat
Tue Nov 21, 2017 10:10 pm
Forum: PowerPivot/DAX
Topic: Average per month
Replies: 2
Views: 1385

Re: Average per month

Hi, Matt, sorry I sent the file wrong, attached again. It is certainly as you say Matt, but it is a question I saw in a forum, and I came to doubt if it is possible to do so in Dax. In Excel it is possible to solve it with two formulas. Thank you.
by okat
Tue Nov 21, 2017 1:15 pm
Forum: PowerPivot/DAX
Topic: Average per month
Replies: 2
Views: 1385

Average per month

How do I find the average monthly sales? Attachment file
by okat
Sat Oct 21, 2017 1:24 pm
Forum: PowerPivot/DAX
Topic: Get a virtual table of dates from a selected date in a slicer
Replies: 3
Views: 1855

Re: Get a virtual table of dates from a selected date in a slicer

Suppose you want to compare employee salaries. The idea is to show the payroll payment of one month compared to the previous month, or to a month selected by the user, concept to concept to revise the percentage variations in each case. I've solved it in part by creating a table called periods, whic...
by okat
Sat Oct 21, 2017 5:40 am
Forum: PowerPivot/DAX
Topic: Get a virtual table of dates from a selected date in a slicer
Replies: 3
Views: 1855

Get a virtual table of dates from a selected date in a slicer

From a date I get with the function DAX SelectValue, I intend to obtain a virtual table with the 6 previous periods. For example if my date is 01/09/2017 get 01/08/2017, 01/07/2017, .... 01/03/2017 And in another column I would like to put an index that goes from the month selected with Indice 0,-1,...
by okat
Wed Sep 20, 2017 11:20 pm
Forum: PowerPivot/DAX
Topic: Take the selected item in a slicer
Replies: 3
Views: 1858

Take the selected item in a slicer

Is there a Dax function that allows me to take the selected item in a slicer?
Regards
by okat
Thu Aug 17, 2017 6:39 am
Forum: PowerPivot/DAX
Topic: Context Transition
Replies: 1
Views: 1261

Context Transition

I have been practicing with the transfer of the filter context in Dax and I am asked the following question in relation to a measure: I have two tables: Sales and Calendar. I have implemented the following measure to calculate the sales of the previous year: 1- CALCULATE(SUM(Sales[Amount]); FILTER(A...

Go to advanced search