Search found 41 matches

by masterelaichi
Tue May 26, 2020 8:17 am
Forum: Power Query
Topic: Merging 2 columns and getting only uniques values
Replies: 3
Views: 609

Re: Merging 2 columns and getting only uniques values

Found a simpler way to do it [img] [attachment=0]Capture.JPG[/attachment] [/img] Here is the code let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"ColumnA", Int64.Type}, {"ColumnB", type tex...
by masterelaichi
Tue May 26, 2020 6:54 am
Forum: Power Query
Topic: Merging 2 columns and getting only uniques values
Replies: 3
Views: 609

Re: Merging 2 columns and getting only uniques values

Hi, This is a bit convoluted and I am sure there is a much better way to do this let Source = Excel.CurrentWorkbook(){[Name="Shift"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"User", type text}, {"Shift1", type text}, {"Shift2"...
by masterelaichi
Tue May 26, 2020 5:50 am
Forum: Power BI Desktop/Service
Topic: Add external tools to Power BI ribbon
Replies: 0
Views: 752

Add external tools to Power BI ribbon

Hi,

I was watching this Microsoft Webinar where the presenter had DAX studio and something call AML toolkit as an add-on in PBI Desktop. He had an extra tab on the ribbon called External tools which had these tools. Any idea how to enable it? Or is it presently available only for MS employees ?
by masterelaichi
Fri May 22, 2020 6:10 am
Forum: Power BI Desktop/Service
Topic: Power BI Map to plot suburb locations
Replies: 2
Views: 281

Re: Power BI Map to plot suburb locations

Thanks Matt

I'll give it a shot
by masterelaichi
Wed May 20, 2020 11:49 am
Forum: Power BI Desktop/Service
Topic: Power BI Map to plot suburb locations
Replies: 2
Views: 281

Power BI Map to plot suburb locations

Hi all, I am trying to create a visual to plot data on a shape map. The map I am need is a one of Queensland with Suburbs or Local government areas An example of using this would be plotting the number of Covid-19 cases in a suburb or a local government area I obtained LGA data from https://data.gov...
by masterelaichi
Wed Oct 24, 2018 5:38 pm
Forum: PowerPivot/DAX
Topic: DAX code to track project progress as at reporting date
Replies: 2
Views: 968

Re: DAX code to track project progress as at reporting date

Thanks for your response. The report that I created works fine when the appropriate filters are chosen What I am trying to achieve is a visual in which, with no filters acting anywhere, eg.- when no date is selected in the Report As At slicer, by default, the visual should display the correct number...
by masterelaichi
Wed Oct 24, 2018 10:25 am
Forum: PowerPivot/DAX
Topic: DAX code to track project progress as at reporting date
Replies: 2
Views: 968

DAX code to track project progress as at reporting date

Hi all, Edit 25/10/2018 : I have posted my query at MrExcel.com as well, in the hopes that I can find a solution sooner. Once I do, I will mark it as solved https://www.mrexcel.com/forum/power-bi/1075342-dax-code-track-project-progress-reporting-date.html#post5165665 I am working on a dashboard that...
by masterelaichi
Mon Jun 04, 2018 4:59 pm
Forum: PowerPivot/DAX
Topic: Time Intelligence webinar- Evaluation of Year to Date Totals
Replies: 5
Views: 2574

Re: Time Intelligence webinar- Evaluation of Year to Date Totals

Hi Matt, Sorry, I should have been more clear when I replied. I was just testing some stuff out to see try and see how the result changes with different formulas. I had a few measures without the ALL and MAX functions as well I will read your explanation a couple of times. Also been reading Rob Coll...
by masterelaichi
Mon Jun 04, 2018 2:47 pm
Forum: PowerPivot/DAX
Topic: Time Intelligence webinar- Evaluation of Year to Date Totals
Replies: 5
Views: 2574

Re: Time Intelligence webinar- Evaluation of Year to Date Totals

Hi Matt, Thanks for the blog. To be honest, I am still confounded by this. Everytime I think of the initial filter context affecting only the FILTER function as explained in your blog, the ALL function pops into my head and I think of the entire table and that really messes things up for me Going to...
by masterelaichi
Mon May 28, 2018 12:57 pm
Forum: PowerPivot/DAX
Topic: Time Intelligence webinar- Evaluation of Year to Date Totals
Replies: 5
Views: 2574

Re: Time Intelligence webinar- Evaluation of Year to Date Totals

Thanks Matt. Looking forward to reading your blog

Go to advanced search

cron