The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi! I am working on summing area for all area that is currently active for each month. Can someone take a look at my DAX code and see where I can fix it or any pointers?
hi @HopeThomas456 ,
that looks like a measure. How are you going to present the measure, or what context do you have for this measure?
If you visualize it with a column from CalendarDates table, most probably you might need to wrap an ALL, like:
Hi @FreemanZ ,
I have tried different DAX codes to try to sum area that is active for the duration of the start and end date and running into some issues. Here is a sample of what my data looks like. Some of my data do not have an end dates so that would indicated that that area is always active. I have changed the date formate from Date/Time/Zone to just Date. Looking to create a stacked bar chart for each month and each bar show the different categories. I can add a slicer so that the chart will filter based on program and shop. I created a basic Calendar that has days, months, quarters, years.
I have tried the following DAX:
Another note that I need guidance on is that if a month isn't present in the Join data I still want it to be present in the stacked bar chart. Any help with this?