Skip to main content
Microsoft Idea

Power BI

Needs Votes

Create a pbix sample that includes DAX functions

Vote (57) Share
Miguel's profile image

Miguel on 03 Nov 2015 20:38:27

We need a sample pbix file (similar to the AdventureWorks SSAS examples) to act as a template we can follow while creating our own.

Comments (18)
Miguel's profile image Profile Picture

Kinga on 06 Jul 2020 00:08:34

RE: Create a pbix sample that includes DAX functions

Please improve the website, instructions do not reflect options available on Power BI service, and there is no .pbix file available.

Miguel's profile image Profile Picture

Dawn Parks on 06 Jul 2020 00:02:05

RE: Create a pbix sample that includes DAX functions

Downloading the Retail Analysis Sample zip file (https://docs.microsoft.com/en-us/power-bi/sample-retail-analysis#get-the-content-pack-for-this-sample) , using the link provided in the filters example (https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter) did not produce a .pbix file that could be accessed and used in Power BI desktop. Can you please provide a better link or more explicit directions for to get the .pbix file?

Miguel's profile image Profile Picture

Rodislav Ivanov on 05 Jul 2020 23:49:28

RE: Create a pbix sample that includes DAX functions

It would be cool if we can access the used data set from the guide formation. It's way much easier to understand by applying these lessons in the same time we watch them. I've tried to use other data sets and adapt it depending on the things every video explains, but the data is different as well as its structure. So I loose time to adapt it by my own in order to have an example to work on so I could understand the video...

Miguel's profile image Profile Picture

Soorya Balachandran on 05 Jul 2020 23:49:26

RE: Create a pbix sample that includes DAX functions

Yes, I would like to know the same. Please provide a tutorial on how to do these samples as many of them are not understood. And the data provided on the excel sheets are different from the one that is shown. For example, for the sample Customer Profitability sample for Power BI, there are no data for target. Please do something about this real quick

Miguel's profile image Profile Picture

eda halis on 05 Jul 2020 23:14:51

RE: Create a pbix sample that includes DAX functions

student

Miguel's profile image Profile Picture

john ridge on 05 Jul 2020 23:03:17

RE: Create a pbix sample that includes DAX functions

'UPDATE:

in the PowerBI web app: :
- neither the "Filled Map" nor the "Map" visual have a VALUE field
- the 2 visuals DO present a proper map when the Country data is placed in field "Location"


in our version of PowerBI desktop app :
- both problems exist

Miguel's profile image Profile Picture

Power BI User on 05 Jul 2020 23:03:16

RE: Create a pbix sample that includes DAX functions

The worked example at
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-importing-and-analyzing-data-from-a-web-page/

does not work for me.

Neither the "Filled Map" nor the "Map" visual have a VALUE field. Neither visual presents a map when the Country data is placed in field "Location"

Miguel's profile image Profile Picture

john ridge on 05 Jul 2020 23:03:16

RE: Create a pbix sample that includes DAX functions

The worked example at

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-importing-and-analyzing-data-from-a-web-page/

does not work for me.

Neither the "Filled Map" nor the "Map" visual have a VALUE field. Neither visual presents a map when the Country data is placed in field "Location"

Miguel's profile image Profile Picture

john ridge on 05 Jul 2020 23:03:16

RE: Create a pbix sample that includes DAX functions

Delete in favour of
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32108974-analyzing-web-page-data-using-power-bi-desktop-tu

Apologies, I logged this anonymously in error
(john ridge)

Miguel's profile image Profile Picture

Luca Spolidoro on 05 Jul 2020 22:50:08

RE: Create a pbix sample that includes DAX functions

We need a sample that will count DAU/MAU metrics and other retention metrics in an easy way.