Search found 6 matches

by jw95
Mon Sep 30, 2019 9:37 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 14 - Repeat Customers
Replies: 4
Views: 877

Re: Chapter 14 - Repeat Customers

Hi Ramana, You are right. I did use filter of more than 1. Using my approach of RELATEDTABLE, I am not able to distinct count specific column such as SalesOrderNo as RELATEDTABLE only allows me to choose table, not column. Now, I am in particular curious to know how would you approach to solve "...
by jw95
Fri Sep 27, 2019 10:22 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 14 - Repeat Customers
Replies: 4
Views: 877

Re: Chapter 14 - Repeat Customers

Hi Ramana, Thanks for responding. I am able to replicate what you suggested. So I continue reading and come to Chapter 16, RELATED and RELATEDTABLE. The example in the book gave me an idea of calculating the no of sales by customer key, to try to answer what I asked earlier, thinking that there are ...
by jw95
Mon Sep 23, 2019 12:17 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Chapter 14 - Repeat Customers
Replies: 4
Views: 877

Chapter 14 - Repeat Customers

Hi all, I like to find out how many repeat customers I have in this database. How do you go about it? I did a DISTINCTCOUNT on [CustomerKey] in the Sales table, the values seems to be the same COUNT on {CustomerKey] in Customers table (See attached). Can I infer that there is no repeat customer? Ass...
by jw95
Wed Sep 18, 2019 2:43 pm
Forum: Power Query
Topic: What does orange colour icon means?
Replies: 1
Views: 759

What does orange colour icon means?

Hi all, This is going to be very basic question for some, I am wondering what is the orange icon means in the pic attached? Also I seem to have 2 same tables in PivotTable Fields, one with the orange icon, one without? What is the difference? Which one should i use? Appreciate some enlightenment. Ma...
by jw95
Tue May 28, 2019 11:55 pm
Forum: Power BI Desktop/Service
Topic: How to customise my own common currency symbols in Modelling Formatting [Solved]
Replies: 2
Views: 1481

Re: How to customise my own common currency symbols in Modelling Formatting [Solved]

Thanks for heads up. Glad that I am not alone here =)

Cheers,
Jeffrey
by jw95
Mon May 27, 2019 5:30 pm
Forum: Power BI Desktop/Service
Topic: How to customise my own common currency symbols in Modelling Formatting [Solved]
Replies: 2
Views: 1481

How to customise my own common currency symbols in Modelling Formatting [Solved]

Dear all, Hi. From what I am about going to ask, will show that I am quite new to PowerBI. I have been doing the exercises in Supercharge PowerBI. I tried to format every currency measures I created with AUD$, but it is not listed on common currency symbols as you can see the screenshot below. How d...

Go to advanced search