none
Getting the substring of CSV File and combine two different columns with a criteria RRS feed

  • Question

  • Am having a Power BI desktop, and connecting to a csv file and I want to extract substrings from the csv file and generate a  clustered column report.

    Below is the column:

    myFileName

    2200_AB_42328_TRT_OKI_RTDA_ABC_ABV_KIU
    2201_AB_35585_VRT_OKI_KLU_VEX_TBB_HC
    2112_AB_35609_TRT_OKI_KLY_VEX_TBB_LR

    2211_AB_42328_TRT_OKI_RTDB_ABC_ABV_KIU
    2223_AB_35585_VRT_OKI_KLU_VEZ_TBB_HC
    2124_AB_35609_TRT_OKI_KLY_VE_TBB_LR

    1) i need to fetch the rows in where substring == TRT 

    2) i dont need to fetch the rows which contains VRT

     

    should i write a  dax query ? something else to get the values ?

    2) There are 2 columns called WFStatus == which has values either "" ( empty) or a string "SUCCEEDED" . 2nd column called MessageStat which has the values 

    DaemonFile()  => " file is empty "

    so, i need to fetch those rows which are having both WFStatus == "SUCCEEDED"  and  MessageStat == DaemonFile()  => " file is empty"

    How to combine these two columns and add it in a clustered chart.


    • Edited by SaMolPP Thursday, August 1, 2019 1:19 PM
    Thursday, August 1, 2019 1:19 PM

Answers