Super Charge Power BI by Matt Allington

Author:Matt Allington
Language: eng
Format: epub
Tags: big data;data analysis;data scientist;excel;excel 2016;Power BI;Business Intelligence;finance;microsoft;msbi;pivot table;pivottable;powerpivot;sharepoint;spreadsheets;DAX;formulas
Publisher: Holy Macro! Books
Published: 2018-01-16T16:00:00+00:00

45. Modifying Practice Exercise 43

Try editing the IF() statement for [Product Sub Category (Values)] so that it returns the value More than 1 SubCategory instead of BLANK(). The syntax for IF is IF(Logical Test, Result if True, Result if False).

46. Modifying Practice Exercise 44

Now try editing the IF() statement for [Product Color (Values)] so that it returns More than 1 Colour instead of BLANK(). You should end up with something like the following (which shows answers for Practice Exercises 45 and 46).

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.