Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I want to calculate the hours difference between Total Hours and orginal work hours which has date slicer .
Dax Query should be written as below and after this conditions have been met then have to calculate the difference between orginal workhours and Total hours
WHERE PROJ.Active = 1 AND TAR.ApprovalStatusID IN (5,7,8)
(TAE.OriginalWorkHours,0) != TAE.Total Hours
TAE.OriginalWorkHours is not null
TAR.ApprovalDateTime>DATEADD(s, -1, DATEADD(m, DATEDIFF(m, 0, @pendwkdate)+1, 0))
then difference between orginalworkhours-Totalhours
I am trying to write the conditions in Dax but its saying its incorrect
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
10 | |
10 | |
9 | |
7 |
User | Count |
---|---|
17 | |
12 | |
11 | |
11 | |
10 |