• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I want help for these questions

neerajdas43

New Member
Q1) Using DAX formulas, create a new column ‘Net_Units’ as the difference of ‘Units’ and ‘Cancelled_Units’ in the sale table



Q2) Using DAX formulas, rename ‘City’ to ‘City_Old’, create new column ‘City’ with only the city name i.e., removing the country part; from the two files ‘‘Mod3_Raw_CityTier_v0 1 ‘and ‘PinCode-Geo’.



Q3) Create a field called ‘OrderDayOfWeek’ which should contain the day of the week, e.g., ‘Monday’



Q4) To be able to look at weekly trends, using DAX formulas, create a field called ‘OrderWeekStart’ which contains the date for the start of the week of the sale. - Note that your week should be starting from Monday - Format this field to display ‘Nov 06’ for November 6th 5. Update the relationships to ensure all tables are connected as expected



Q5) Tax Slab Calculation: All the products sold (profit column) from the store are taxed with a standard tax slab of 2%. Your manager wants you to create a tax slab column so that it can be used for visualization.



Q6) Performance of Query: The manager also wants to check on the performance of the power query. So, he is asking to generate the metric table as well.





After completing your task. You have been requested to submit your .pbix file.



DataSet to be used:

For questions: 1, 2, 3, 4 follow the 5 files

For questions: 5, 6 use the order table.csv
 
Yep, someone'll do your assignment/test for you; they'll even use those data files mentioned.
 
Back
Top