Search found 7 matches

by smjzahid
Wed Feb 13, 2019 12:41 am
Forum: PowerPivot/DAX
Topic: Excel formula to DAX Conversion
Replies: 4
Views: 709

Re: Excel formula to DAX Conversion

Hi PhilC Thank you for your explanation and suggestion, I would request you to please find the PBIX file attached the name of the calculation is DUE. I agree with you that writing a measure will keep the file size smaller as compared to calculated columns. The attached file contains a calculated col...
by smjzahid
Mon Feb 11, 2019 1:33 am
Forum: PowerPivot/DAX
Topic: Excel formula to DAX Conversion
Replies: 4
Views: 709

Excel formula to DAX Conversion

HI All I am new to DAX could you please help me convert below written Formula in Excel Workbook to DAX. (as we are migrating to Power BI). I am also attaching sample Excel File for your perusal and the formula that needs conversion to DAX is written in Column L. (Just place your cursor on cell L9 to...
by smjzahid
Thu Sep 13, 2018 1:43 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 2230

Re: SUMX Giving Incorrect Grand Total

Hi Matt Yes you were right (as usual :) ) It was my mistake not to close the bracket properly, Your formula has worked as far as I am concerned. However, I have asked my Finance guys to cross check the figure in the Power BI report until then let us assume that it is correct. I have a second query t...
by smjzahid
Tue Sep 11, 2018 6:25 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 2230

Re: SUMX Giving Incorrect Grand Total

Sorry about that, Here is it is

sumx(values(vw_dsf_final[cbu]),CALCULATE(SUM(vw_dsf_final[cy mtd]/SUM(vw_dsf_final[py mtd]))))
by smjzahid
Mon Sep 10, 2018 6:45 pm
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 2230

Re: SUMX Giving Incorrect Grand Total

Hi Matt Yes I have tried your new suggestion. However, I get an error as I type in the formula in Power BI (See below is the actual error I copied from Power BI and pasted here) The%20syntax%20for%20')'%20is%20incorrect.%20(DAX(%20sumx(values(vw_dsf_final[cbu]),CALCULATE(SUM(vw_dsf_final[cy%20mtd]/S...
by smjzahid
Mon Sep 10, 2018 3:22 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 2230

Re: SUMX Giving Incorrect Grand Total

Hi Matt Thank you for your reply, I have read your blog on difference between SUM and SUMX (very informative), I did tried to apply the suggestion below but as you rightly mention that you are proposing a solution without complete understanding of the data model. Here are the details on the data mod...
by smjzahid
Sun Sep 09, 2018 1:57 am
Forum: PowerPivot/DAX
Topic: SUMX Giving Incorrect Grand Total
Replies: 9
Views: 2230

SUMX Giving Incorrect Grand Total

Hi All I am using Power Bi Desktop and via Import connection method connecting to a view on Amazon Redshift. I am using the table visual to show the data on power BI Desktop. I am new to DAX, I have created a SUMX function as per below requirement. What I want is the grand total to appear as -16.8 w...

Go to advanced search