Search found 14 matches

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: 0
Views: 94

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

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

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

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

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

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

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

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

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?
by okat
Fri Jun 16, 2017 12:25 pm
Forum: Power BI Desktop/Service
Topic: Power BI service does not update the dataset of a local Excel file
Replies: 1
Views: 704

Power BI service does not update the dataset of a local Excel file

I'm loading in the Power BI service in the cloud a dataset from a local Excel file http://bit.ly/2ttj0dk. I made a modification to the aforementioned Excel file, I basically added a new measure, but when I reload in the cloud, overwriting the data, the dataset does not reflect the changes made, alth...

Go to advanced search

cron