Search found 15 matches

by okat
Sat Apr 07, 2018 12:55 am
Forum: Power Query
Topic: Check all columns
Replies: 3
Views: 255

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: 620

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: 612

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: 824

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: 824

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: 1123

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: 1123

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: 1074

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: 690

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...
by okat
Wed Jul 05, 2017 9:47 am
Forum: Power BI Desktop/Service
Topic: Row Level Security
Replies: 1
Views: 1246

Row Level Security

It is a company that has 70 vendors. Vendors can access a part of the report individually. Do I have to create a role for each salesperson? Is there another way to do it?

Go to advanced search