“Doing Power BI the Right Way: 7. Validating data model results” - Ilgar Zarbaliyev's Nuzzel Newsletter for Sun, Oct 11

Moving important business data into a data model for analytic reporting can often be a two-edge sword. Data retrieval is fast and can support all kinds of analytic trending and comparisons. But, data in the model may be one or two layers away from…

Shared by…

3

More info…

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event…

Shared by…

2

More info…

Formula in cell D4: =IF(ROWS($B$4:B4)>$B$14,””,VLOOKUP(ROWS($B$4:B4),$B$4:$C$14,2,FALSE)) Formula in cell B5: =IF(COUNTIF($C$4:C5,C5)=1,B4+1,B4) In cell B4 value 1 is input manual.

Shared by…

1

More info…

Solution: =INDEX($C$3:$C$11, SMALL(IF(ISNUMBER(SEARCH($F$2, $B$3:$B$11)), MATCH(ROW($B$3:$B$11), ROW($B$3:$B$11))), ROWS($A$1:A1))) Array Formula: CTRL + SHIFT + ENTER…

Shared by…

1

More info…

New York(CNN Business) If you've bought furniture, clothing, or electronics online recently, chances are you've seen a new option that lets you put off paying for an item in full all at once. Retailers from Nordstrom (JWN) to Sephora are allowing…

Shared by…

1

More info…