The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredAsk the Fabric Databases & App Development teams anything! Live on Reddit on August 26th. Learn more.
I promise I did my research on the internet before I post a new thread here. lol
I have a table like this:
Final | Xtime Start Date | End Date | Xtime End Date | Export Date | Days Count | $/day |
CM | 1/15/2024 | 1/31/2024 | 3/8/2024 | 17 | 20 | |
2/1/2024 | 2/20/2024 | 3/3/2024 | 20 | 55 | ||
0 | 1/20/2024 | 2/5/2024 | 3/8/2027 | 0 | 15 | |
End 2/28 | 2/22/2024 | 2/28/2024 | 3/5/2024 | 7 | 26 | |
End 3/5 | 2/22/2024 | 3/5/2024 | 3/8/2024 | 3/3/2024 | 13 | 14 |
When the column Final is "CM" or blank, use column Xtime Start Date and Xtime End Date to calculate Days Count. When column Final is 0, Days Count is 0. When column Final has an "End" date, use column Xtime Start Date and End Date to calculate Days Count. I need to create a meausure to calculate the Days Count for different months. I don't even know where to start since there are different date columns for different values from column Final. When I create a bar chart based on time (year.month), I will be able to see Days Count by month. Help PLEASE!
Solved! Go to Solution.
Thank you so much @ibendlin. It worked!