Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Help Converting an Excel countifs function into Power BI

Hi all,   I am new to the forum and new to Power-Bi and I really need a little help.   I have been given an excel sheet and asked to convert it to Power-Bi. I am really stuck with 1 formula in pa...
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Anonymous

 

Try this calculated column for "number of single picks in aisle for single item orders"

 

number of single picks =
VAR check =
    COUNTROWS (
        FILTER (
            ALL ( Orderwell_Summary ),
            Orderwell_Summary[Column1] = EARLIER ( Orderwell_Summary[Column1] )
                && Orderwell_Summary[no. order lines] = 1
        )
    )
RETURN
    IF ( check >= 1, check, 0 )

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Anonymous

 

Try this calculated column for "duplicate pick locs for single item orders"

duplicate pick locs =
VAR check =
    COUNTROWS (
        FILTER (
            ALL ( Orderwell_Summary ),
            Orderwell_Summary[Pick-Loc] = EARLIER ( Orderwell_Summary[Pick-Loc] )
                && Orderwell_Summary[no. order lines] = 1
        )
    )
RETURN
    IF ( check >= 1, check, 0 )