abbasabdulla Tracker

Re: Sum two columns if third column contains text

abbasabdulla — Thu, 30 Aug 2018 13:09:44 GMT

Hi, I don't know which powerbi products do you test my function in, I have tested it using Power BI Desktop Version: 2.41.4581.361 64-bit (November, 2016) Check the below Pibx file I worked on. https://drive.google.com/open?id=12RIcR-QVFB1waMO2w56n4OD9iq8byHcD

Re: Sum two columns if third column contains text

abbasabdulla — Wed, 29 Aug 2018 08:27:48 GMT

Hi,

Try this function in Caluclated Column

if Text.Contains([A], "ing") or  Text.Contains([A], "fy") then [B]+[C] else [B]

Re: Need Help with Custom Week of month number

abbasabdulla — Wed, 29 Aug 2018 08:29:14 GMT

Try using this function

= 1 + WEEKNUM ( Dates[Date],2)-WEEKNUM( DATE(YEAR(Dates[Date]),MONTH(Dates[Date]),1),2)

Re: Grouping Data by Time Frame

abbasabdulla — Tue, 28 Aug 2018 10:53:33 GMT

Hi,

Try the below function as Calculated Column

let
  daysuntilltoday= (DateTime.Date(DateTime.LocalNow())-[CHECK_DATE]),

 d= Int64.From(daysuntilltoday),

tag= if d >=90 and d <=120 then "90-120 Days" else if d >=121 and d <=180 then "121-180 Days" else
if d >=181 then "181 and greater" else "Another group"

in
  tag

Then group your data using this column

Re: Need Help with Custom Week of month number

abbasabdulla — Mon, 27 Aug 2018 21:28:17 GMT

Hi,

Does changing 21 to 2 in your function solve this? Why you put the 21?

weekinmonth = 1 + WEEKNUM ( Dates[Date],2)-WEEKNUM( STARTOFMONTH (Dates[Date]),2)

Re: How to check for CSV file existence before trying to load it with File.Contents?

abbasabdulla — Sat, 25 Aug 2018 01:59:29 GMT

Hi,

Can you give this code a try!

let
    Source = Folder.Files("ReportDataFolderPath & "\subfolder\"),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Name] = "filewithdata.csv")),
    #"Counted Rows" = if Table.RowCount(#"Filtered Rows")= 1 then
let
SourceFile = Csv.Document(File.Contents("ReportDataFolderPath & "\subfolder\filewithdata.csv"),[Delimiter=",", Columns=18, Encoding=65001, QuoteStyle=QuoteStyle.Csv]),
    #"Promoted Headers" = Table.PromoteHeaders(SourceFile, [PromoteAllScalars=true])
in
#"Promoted Headers" 
else 
"File is not found"
in
    #"Counted Rows"

OR check this post it has more sophisticated method: https://community.powerbi.com/t5/Integrations-with-Files-and/How-to-check-if-a-file-exists/m-p/66259/highlight/true#M5221

Re: Need help with DAX equation

abbasabdulla — Sat, 25 Aug 2018 00:17:17 GMT

Hi,

Try using this DAX

IF('Active RCA Audit'[POE Chargeable]="POE",
BLANK(),If(OR(SEARCH("Procedural",'Active RCA Audit'[DIRECT CAUSE],1,FALSE()),SEARCH("Procedural",'Active RCA Audit'[ROOT CAUSE],1,FALSE())),"Potential",BLANK()))

Re: Appended CSVs, searching rows to promote headers

abbasabdulla — Tue, 14 Aug 2018 10:25:35 GMT

Hi,

Check the linked file https://www.dropbox.com/s/6pdix2vg1dl27l1/Append%20CSV%20PQ.xlsx?dl=0

will this solution works for you?

Re: Change month name language in Power Query

abbasabdulla — Tue, 14 Aug 2018 09:20:08 GMT

Hi,

The month name will follow Locale , to change it follow the below steps

Goto : File > Options and Settings > Query Options > Current Workbook Data Load

Finally change the Locale from the list.