Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have two types of projects 1. Agile 2. Software. The below formulas apply to both the Project types. Initially our projects took 3 months to complete but lately it was taking 6 months so I wanted to show the 3 months data in 6 months and took an expert's help from the community. But the issue now I'm facing is I want to show the data from 3 months to 6 months for Agile projects only not for Software projects since they take 3 months to complete, so the old formula (3 months formula) works fine for Software projects. Could anyone please suggest if there is any DAX formula or IF condition that we can apply to show 6 months formula for Agile and 3 months formula for Software. For Agile projects we take 60 Hours and for Software projects we take 6 hrs to complete
FYI - I need to show both Agile and Software projects types in the same stacked column chart so I cannot add two different tables in PowerBI and need one combined formula to suffice both the needs.
Sample table for your reference
Id | Title | Supply type per_ | Projects | Status | LeadTime | HoursTotal | Date | hoursweek | hourspending1 | nextmonth1 | hourspending2 | nextmonth2 | workhours1 | workhours2 | workhours3 | Date Completed |
1 | A | Stragetic | Agile | active | 12 | 60 | 1/9/2024 | 5 | 40 | 2/9/2024 0:00 | 20 | 3/9/2024 0:00 | 10 | 10 | 10 | |
2 | B | Operational | Software | active | 1 | 6 | 2/15/2024 | 1 | 3 | 3/15/2024 | 3 | 4/15/2024 | 3 | 3 | 0 |
3 months Formula:
@royalty123 we can work it out with a dynamic calculation.
check and let us know if it works.
calculated column:
LeadTime =
IF ( Projects[ProjectType] = "Agile", 12, 3 )
use this in the visual.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |