Search found 10 matches

by Kamran_bsh
Wed Aug 29, 2018 5:37 am
Forum: PowerPivot/DAX
Topic: Calculate the max for a group using table columns and measures
Replies: 2
Views: 533

Re: Calculate the max for a group using table columns and measures

Hi TheFred,

Please see attached.

I have used a different approach though but it does give the result you want.

Thanks
by Kamran_bsh
Sat Aug 25, 2018 5:39 am
Forum: PowerPivot/DAX
Topic: AUS Date Chnged to US in Power Pivot Data Model
Replies: 3
Views: 1324

Re: AUS Date Chnged to US in Power Pivot Data Model

Excel settings are different from those of power query. You can change your regional settings temporarily in control panel and that will fix the problem. Or you can change locale from excel.
Remember you need to keep USA settings, not AUS because your data is in US format.
by Kamran_bsh
Wed Aug 22, 2018 8:46 am
Forum: PowerPivot/DAX
Topic: Date filter having unexpected effect
Replies: 1
Views: 165

Re: Date filter having unexpected effect

Hi James, The reason for this behaviour is filter context. When you select a different year the filter context changes and that is probably the reason why your value disappears or is returning a blank as per the formula you are using. It would be helpful if you upload a small sample of your data mod...
by Kamran_bsh
Mon Aug 20, 2018 3:06 am
Forum: PowerPivot/DAX
Topic: Cumulative sum (DAX formula)
Replies: 8
Views: 758

Re: Cumulative sum (DAX formula)

Glad it works. You are Welcome ;)
by Kamran_bsh
Mon Aug 20, 2018 2:19 am
Forum: PowerPivot/DAX
Topic: Cumulative sum (DAX formula)
Replies: 8
Views: 758

Re: Cumulative sum (DAX formula)

Please see attached. Like I said only use two tables. Sales as data table Dates as lookup table. If you are using excel 2010 you wont be able to insert date table from power pivot window I think you have to use power query to generate date table. Or see if calendar auto or calendar functions are ava...
by Kamran_bsh
Mon Aug 20, 2018 1:37 am
Forum: PowerPivot/DAX
Topic: Cumulative sum (DAX formula)
Replies: 8
Views: 758

Re: Cumulative sum (DAX formula)

Hi Have a look.I have changed column names to English because I was struggling with language in the model :D . I have put pivot table for you based on the first image you provided. I am assuming this is what your end goal was. Measures i have done are Actual YTD & Budget YTD. Also, you only need...
by Kamran_bsh
Sun Aug 19, 2018 5:39 pm
Forum: PowerPivot/DAX
Topic: Cumulative sum (DAX formula)
Replies: 8
Views: 758

Re: Cumulative sum (DAX formula)

Do you have a sample file? I need to look at data. Please trim data out of your model and provide workbook.
by Kamran_bsh
Sat Aug 18, 2018 8:41 am
Forum: Power Query
Topic: Add Conditional Column
Replies: 2
Views: 468

Re: Add Conditional Column

Please upload the file. There might be a solution. I will give it a try :-) besides Matt might reply if he gets a chance, am sure he would know a way to do this.
by Kamran_bsh
Wed Aug 15, 2018 4:57 pm
Forum: PowerPivot/DAX
Topic: Applying What if Parameter only to certain value
Replies: 1
Views: 281

Re: Applying What if Parameter only to certain value

Please upload your excel file and expand your question a little. Struggling to understand what exactly you are trying to achieve(still want to show the total of other hours part I don't get)
by Kamran_bsh
Wed Aug 15, 2018 6:57 am
Forum: Excel
Topic: Excel "Best Practice Guidelines" to implement into business
Replies: 1
Views: 390

Re: Excel "Best Practice Guidelines" to implement into business

There is a framework by the Institute of Chartered Accountants in England & Wales which highlights best practices for spreadsheet design. But, your focus is on pivot tables. In my experience 1)You can use custom formatting options and design a template for pivot table formatting which will save ...

Go to advanced search