Forum Discussion

samoberoi's avatar
samoberoi
Helper III
2 years ago
Solved

Network days from a certain date

Hi All,   I have a query on some work which has previously been done on Excel and now it has to be done on Power BI. It is just to calculate the number of network days from a joining or leaving dat...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago
when i put this measure in the table visual along with other field values, it comes up with the error as below

In my COALESCE formulas you can replace the hardcoded dates with your min and max fact dates.

 

 if i filter by April in slicer

Filter? Slicer?  That was not mentioned as a requirement.  Your slicer would need to be fed by a disconnected table.

 

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

samoberoi's avatar
samoberoi
Helper III
2 years ago

 

 

EXPECTED RESULTS

  April capacity (Days)May capacity (Days)June capacity (Days)July capacity (Days)
AA-BB-123 16232023
AA-BC-125 22232023
AA-BB-124 5000
AC-BC-123 001423
CA-BB-125 22500
AD-BD-123 22232023
AA-BB-111 6000

 

 

SECOND ISSUE

 

  1. In my COALESCE formulas you can replace the hardcoded dates with your min and max fact dates.

Related to the second issue, i tried to use Min & Max for the dates from the fact table Table A in this example, but it still doesn't work.

 

Hope i could be explain it better and could be provide better sample data.

 

Thanks again.