I’m a Tableau user and switching to PowerBI. I’m trying to migrate a dashboard from Tableau to PowerBI. I created a LoD filter that checks if the total working hours are greater than 1600 and count Employee ID. The numbers are not match as Tableau is using a contextual filter. The formula I created for total working hours is:

I need to make something like this (originally from Excel):

Hi I have table named:’reporting CC Admission’ with a column called ‘DateOfAdmissionToBH’ and another table named ‘column’ with a column name ‘DateOfReferral’.
I have tried using dateddiff to calculate the number of days from referral to admission and related but cannot get the syntax right. Can anyone help please? Do I need to join the tables to create the calculated column.

In PowerBI, I have a report containing a table displaying open and closed projects that meet one or more of a criteria. I have separate Opened Date and Closed Date slicer to narrow the results of the table. However, due to the closed date slicer, open items without closed dates are excluded. Any way I could have a closed date slicer while also including open items that meet the criteria?

I am currently working on a Power BI report where I need to present both a summarized version of the data within a table as well as be able to view the individual rows of the same table but filtered by the summarized information.

in Power BI, I have a clustered Bar Chart.

I’m currently having this annoying problem with the funnel chart visual.

I want to create a rank grouping by month and category using dax. Basically, like that:

I have a orign that is a call from an API and on the desktop the data make sense and it’s everything ok, BUT, when i publish the dashboard and the data updates some weird data appairs. Data that doenst even exists.

Is there any way we can merge two separate .PBIX files into single file?