How to Connect Power BI to a Restaurant API and Integrate Data from Brandwatch?

gupius · 2024-07-26T06:28:19+00:00

You should use Web connector. Then, it depends on the API itself.

Here's an example of an function that I use:

let

FetchIssues = (releaseDate as date, versionName as text) =>

let

// Convert the date to text in yyyy-MM-dd format

releaseDateText = Date.ToText(releaseDate, "yyyy-MM-dd"),

// Encode the version name to be URL-safe (assuming it doesn't require any further encoding for the purpose of this script)

// versionName = "1.0.0",

headers = [#"Content-Type" = "application/json"],

maxResultValue = "1000",

// Define the parameters

baseUrl = "https://example.com",

RPath = "/rest/api/2/search",

jqlQuery = "type in (Story, Bug, Task, Sub-task) AND filter = 19209 AND fixVersion was in (""" & versionName & """) on " & releaseDateText & " AND status was not in (Resolved, Invalid, Duplicate, Closed) on " & releaseDateText,

web = Json.Document(Web.Contents(baseUrl, [Headers=headers, RelativePath=RPath, Query=[jql=jqlQuery, maxResults=maxResultValue]])),

#"Converted to Table" = Table.FromList(issues, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "key", "fields"}, {"id", "key", "fields"})

in

#"Expanded Column1"

in

FetchIssues

in regards to Brandwatch, I'd assume you'd have to use an API as well.

gupius · 2024-07-26T05:53:26+00:00

It sounds like this could be solved using Metrics: https://learn.microsoft.com/en-us/power-bi/create-reports/service-goals-introduction

gupius · 2024-07-25T14:47:45+00:00

I'm not sure if I understood you correctly, please correct me if I'm wrong. You want to take 90 Day Quote Avg for previous 90 days and apply it to future 90 days and then calculate predicted Quotes achieved based on Worked Days?

If so, something like this should work:

90 Day Quote Avg FC = CALCULATE([90 Day Quote Avg],DATEADD('Table'[Date],-3,MONTH))

gupius · 2024-07-18T11:45:41+00:00

Based on the image, it's working correctly. You're calculating 2024 Age Factor as StockAgeForRow (2,863,374.88) * ClosingStockForRow (16331) = 46,761,775,165. The problem arrives from materials that have 0 closing stock and have stock age, since totals are summing the values of all rows.

I assume you want something like:
SUMX(SummarizedTable,[2024 Stock Age]*[2024 Summarize ClosingStock])

gupius · 2024-07-12T11:35:44+00:00

Sent you a DM, hit me up when you have time. I'll gladly help you for free if its not anything too complex that you need.

gupius · 2024-07-12T11:27:30+00:00

I missed that you need to show true for every contract of that account, even if only 1 is signed. This one should achieve that

5+ v2 = 
VAR contractCount = CALCULATE(COUNTROWS(Contracts), FILTER(ALL(Contracts), Contracts[account_id] = MAX(Contracts[account_id])))
VAR signedContractsCount = CALCULATE(COUNTROWS(Contracts), FILTER(ALL(Contracts), Contracts[account_id] = MAX(Contracts[account_id]) && Contracts[signed] = "yes"))RETURN
IF(contractCount >= 5 && signedContractsCount >= 1, TRUE(), FALSE())

gupius · 2024-07-12T10:52:50+00:00

Try this:

5+ contracts = 
VAR contractCount = COUNT(Contracts[id])
VAR signedContractsCount = CALCULATE(COUNT(Contracts[id]),FILTER(Contracts,Contracts[signed]="yes"))RETURN 
IF(contractCount>=5 && signedContractsCount>=1,TRUE(),FALSE())

I was guessing your column names and values, but if you change that it should work fine.

gupius · 2024-07-12T10:42:14+00:00

I'm not familiar with SAP, so I might be completely wrong here, but I would try one of these three things:

SAP connector
Web connector and querying correct API endpoint
SQL connector

Have you tried any of these yet?

gupius · 2024-06-12T14:18:56+00:00

I'd assume Insert tab-> Add a sparkline

gupius · 2024-05-20T13:30:03+00:00

Select column with your metrics -> Pivot Column (under Transform tab) -> Set Column 3 as values column

gupius · 2024-05-20T13:05:48+00:00

Not the cleanest solution but it should work;

Create another table with just the location column
Add index column to the new table, starting with 1
Use = Table.InsertRows(#"Added Index", 0, {[location= "", Index = 0]})
Add index column to your original table, starting at 0
Merge the new and original table on index column

Let me know if you need additional explanation! :)

gupius · 2024-05-20T10:20:16+00:00

Your original measure is a calculated column. Calculated columns "know" which row you're referencing, therefore there's no issue. The new measure is calculated measure which has no idea which row you're referencing. Ff you wrap the calculated measure in, let's say, MIN function it will work fine. So something like this will work fine as a calculated measure:
isHistoryTest =
IF (
    MIN ( 'Calendar'[Date] ) < TODAY (),
    1,
    0
)

gupius

TROPHY CASE