6 questions from the last 7 days
1
vote
1
answer
67
views
Remove Cast on int fields on directQuery to 2 billion row fact when computing averages
Using Power BI directQuery to databricks SQL warehouse, I see the queries getting generated to compute an average have
SELECT
SUM(CAST(int_field AS DOUBLE)), COUNT(int_field)
FROM
fact
...
- 11
Best practices
1
vote
0
replies
27
views
Power BI slicer based on value in one columns and condition that this value is not available in related table
I have two related tables:
SD with columns: No, Date, etc.
Orders with columns: SDNo_, Date, etc.
Both are related with this No - SDNo as one SD to many Orders.
There some No, which are present in ...
Advice
0
votes
0
replies
15
views
Power BI stacked column chart values change incorrectly when multiple selections are made in the slicer
I have a stacked column chart in Power BI showing hours worked per staff on respective tasks.
Table: Tasks
Fields:
X-axis: Tasks[EmpName]
Values: Tasks[totalhrs] / 7
Legend: Tasks[Taskname]
...
- 5