Skip to main content

Power BI

New

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

5d5b387b e056-4cf4-89d4-788e28353e34 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

d87be8f6 474d-476a-9d4a-1c3f0fa962eb 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

a441a2a8 1643-490d-a184-7ef4aaa7997a 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

8e8859f5 7e7c-4108-90b7-969d5f4a101c 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

e3530f8c 82ae-4df3-a9e9-c5f42b06ac4e on 05 Jul 2020 23:14:51

RE: Create a pbix sample that includes DAX functions

student

Miguel's profile image Profile Picture

5ae6970b d513-4bac-8266-a781c4dd19aa 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

17d7daa4 9bc1-43a3-98c1-0fb3735cf8d3 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

5ae6970b d513-4bac-8266-a781c4dd19aa 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

5ae6970b d513-4bac-8266-a781c4dd19aa 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

f88f3897 af7e-467e-ac5e-bcb3533164e7 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.