Search found 10 matches

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

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

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

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

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

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

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...
by okat
Tue May 30, 2017 10:57 pm
Forum: Power BI Desktop/Service
Topic: Share reports with Power BI
Replies: 0
Views: 314

Share reports with Power BI

I am a free power bi user, with the modifications that Microsoft has implemented, as I do to share my reports with clients?
Regards,
by okat
Tue Apr 18, 2017 12:53 pm
Forum: PowerPivot/DAX
Topic: Building a spinner with slicers
Replies: 2
Views: 348

Re: Building a spinner with slicers

Thank You Matt. Someone wanted to implement this but using Power BI.
by okat
Tue Apr 18, 2017 6:00 am
Forum: PowerPivot/DAX
Topic: Building a spinner with slicers
Replies: 2
Views: 348

Building a spinner with slicers

I would like know if you can build a spinner, same style as in excel, with slicers to vary from 0 to 100. I would like to apply it as a percentage that varies according to the selection made.
Regards.
by okat
Tue Apr 18, 2017 4:44 am
Forum: Power Query
Topic: Difference between years
Replies: 1
Views: 430

Difference between years

I have an annual series of data over a period of 10 years and I would like to know the differences from one year to another. How could you implement this in power query?
Regards.

Go to advanced search