Search found 929 matches

by MattAllington
Mon Jan 01, 2018 8:04 am
Forum: Help with the Book "Supercharge Power BI"
Topic: 'Calendar'
Replies: 1
Views: 464

Re: 'Calendar'

The word Calendar is a reserved word in Power BI. It is actually a function that can be used to create a calendar table. If you want to use it as a name of a table (as most users do), you must use single quotes to differentiate it from the function.
by MattAllington
Thu Dec 28, 2017 7:13 am
Forum: PowerPivot/DAX
Topic: Dax Max Month
Replies: 1
Views: 757

Re: Dax Max Month

If you want to do time intelligence calcs (and let's face it - who doesn't), you really should get a calendar table. Read my articles here

https://exceleratorbi.com.au/power-pivo ... ar-tables/
https://exceleratorbi.com.au/dax-time-i ... beginners/
by MattAllington
Wed Dec 20, 2017 11:50 am
Forum: Help with the Book "Supercharge Power BI"
Topic: Where to buy the book
Replies: 1
Views: 721

Where to buy the book

You can read all about the book and find purchase options here https://exceleratorbi.com.au/supercharge-power-bi-book/

Alternatively you may like to consider my online training course that uses the book as the curriculum. https://exceleratorbi.com.au/power-bi-online-training/
by MattAllington
Tue Dec 12, 2017 6:47 am
Forum: PowerPivot/DAX
Topic: Circular Reference
Replies: 4
Views: 1130

Re: Circular Reference

I don't know which table has your formula, and as I said previously (I think) is that it is hard for me to help because I don't understand all the background and the effort for me to come up to speed is high. So my approach to this is to try to guide you to help yourself. The difference between a me...
by MattAllington
Sat Dec 09, 2017 7:12 am
Forum: PowerPivot/DAX
Topic: How to calculate 2 values from the same column
Replies: 4
Views: 748

Re: How to calculate 2 values from the same column

I mean the pivot table, sorry.

Create a new pivot table
Put the 4 columns in your table 2 on rows in the pivot
Change the pivot table settings to be Tabular format and not show sub totals
Add the measure to values
by MattAllington
Fri Dec 08, 2017 5:51 am
Forum: PowerPivot/DAX
Topic: How to calculate 2 values from the same column
Replies: 4
Views: 748

Re: How to calculate 2 values from the same column

This should be standard dax. Load the original table as is. Set up a new table like your table 2. The formula for the measure is

Raw=sum(tablename[act])
Final=Divide(calculate([raw],tablename[nb_na]=“recette”),calculate([raw],tablename[nb_na]=“frequentation”)
by MattAllington
Thu Nov 30, 2017 5:22 pm
Forum: PowerPivot/DAX
Topic: Pivot Table with last date transactions [Solved]
Replies: 1
Views: 567

Re: Pivot Table with last date transactions [Solved]

There are a few ways, but probably the easiest and maybe even most efficient is to add a calculated column to your calendar table something like this. I think this will work IsLastDate = if(Calendar[Date]) = lastdate(TransactionTable[Date]),TRUE(),FALSE()) You can then filter on this column in your ...
by MattAllington
Thu Nov 30, 2017 5:16 pm
Forum: Power Query
Topic: Formatted data Cleaning
Replies: 1
Views: 622

Re: Formatted data Cleaning

How about this as an approach. 1. Duplicate the column 2. Split on the space character 3. add a custom column that checks the length of the 3 columns to make sure they are 3, 4, 4 respectively Custom column = Table.AddColumn(#"Split Column by Delimiter", "Custom", each if Text.Le...
by MattAllington
Thu Nov 30, 2017 12:16 pm
Forum: PowerPivot/DAX
Topic: Circular Reference
Replies: 4
Views: 1130

Re: Circular Reference

Well it's a lot to try to take in. But from what I can see, [Anchor 2] is being referenced inside E20-Anchor2 and then you are trying to add it again into a downstream measure. Maybe you can just duplicate the measure Anchor 2 and use the same formula. I don't know if that would work or not. Another...
by MattAllington
Wed Nov 29, 2017 10:02 am
Forum: Power Query
Topic: Which tables/queries are using most space and refresh time
Replies: 3
Views: 703

Re: Which tables/queries are using most space and refresh time

Thanks. Yes it seems there is a new bug in my workbook. MS keeps changing how it works and I have to keep changing the workbook. You can use DAX Studio to extract the table sizes manually. Here is an intro to DAX Studio https://exceleratorbi.com.au/getting-started-dax-studio/ And here is the SQL to ...

Go to advanced search

cron