Forum Discussion

sbmeder's avatar
sbmeder
Helper I
9 years ago
Solved

Average Invoice Value

Have a table that displays customer name, customers gross sale values for a filtered time period and the number of invoices relating to those sales. Want to add another column in the report that show...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    sbmeder

     

    You can use the same Dax Formula like a measure instead of a calculated Column

     

sbmeder's avatar
sbmeder
Helper I
9 years ago

Unfortunately, I have not had a chance.  I have finally gotten my owner's attention with this product and what it can do for the Company. What is the best way to find consultants to help structure reports so we can slice and dice the data.  My main issue is dealing with the date functionality. I am not a programmer, and I know BI will do what I want it to do, but I have no idea how to write DAX.  looking at customer sales, last month vs this month. Last year vs This year. Same thing with Product lines and Geographic data. 

 

Any help would be appreciated. 

 

Regards,

 

Scott

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi sbmeder,

 

That's all right! We have a lot DAX experts in the forum. If you have any issue with DAX, just create a new thread, and post your table structures with some sample data and your expected result. I'm sure you will get the issue resolved.:smileywink:

 

Regards