DAX to flatten incoming sales forecast by month with correct subtotals
I have a dataset that projects incoming sales forecast but the day of the month the forecast is projected for is not accurate to when the sales will actually occur. I want to "smooth" the forecast data by calculating the average for the month and assigning it to each day. The ultimate goal is to be able to calculate totals based on past real data and future forecast data and be able to have the subtotals calculate correctly even when "today" is within the summarized period of time. At the moment I am able to get the "Daily Average Forecast" and assign it to the first day of the month, but I am struggling to have it apply to each day of the month and to get the sub-total to be a sum of the previously calculated daily values. I would share code I have written so far but I have tried so many permutations of SUMMARIZECOLUMNS and SUMX that I can't remember what worked best already. I am using Melissa de Korte's Extended Date Table and have Time Intelligence switched off in my model and implicit calculations are disabled.Date slicer label not working on table
Hello, Power BI experts...., I have a visual that have slicer date_2 as follow, in the example I choose "February" as month and "2025" as year. I then make a measure of CurrentMonth MTD = LASTDATE(Date_2[Date]) When I test the measure on card visual, it shows end of February, as expected However, when I put the measure on a column in the table as follow, it instead show "Dec 2025" not "Feb 2025", the slicer didn't seem to work on the table The endgoal is to make the label shown on x-axis of a line and clustered Is there any workaround to make the label can follow the slicer. This is quite frustrating since I have got all the amount on the visual correct following the slicer, but not the date label. Thank you in advance!
Adding Calculated Column to Date Table based on Date Ranges in Another table
Hi All, I am looking for some help adding a column to my date table based on date start and end found in another table. What I am trying to do is to add a column to my date table which specifies for each date in the table, which semester it falls into. The dates for each semester can be found in the Semester Date table. There is a start and end date for each semester. I have tried to adapt the solution found in another post. The issue I am having is that the column is currently only returning the final semester found in the Semester Date table. The DAX I have is Semester Date = VAR _a = SELECTEDVALUE ( 'Date'[Date] ) RETURN CALCULATE ( MAX( 'Semester Dates'[Academic Semester]), FILTER ( ALL ( 'Semester Dates' ), 'Semester Dates'[Start]>= _a && _a <= 'Semester Dates'[End] ) ) Date Table; Semester Date Table; Any help would be greatly appreciated. Many thanks
Measure dosen't work with date hierarhy
Hi ! Task : I need to filter the visualization table. Show records whose creation date falls within the date range from the slicer. need to use date hierarchy in slicer (screenshot attached). it should be possible to select the year, apartment, month, week I have a date dimension table that has no links to a records table. so I'm trying to create a measure that will help filter the records. I managed to filter using slicer "between" without hierarchy date. 1. How slicer should look like: 2. Code which i try to make it work : MAX_DATE = VAR year_max = MAX( VW_DIM_DATE[YEAR]) VAR month_max = MAX( VW_DIM_DATE[MONTH_ID]) VAR day_max= MAX( VW_DIM_DATE[DAY_OF_MONTH] ) RETURN DATE ( year_max,month_max,day_max ) MIN_DATE = VAR year_min = Min( VW_DIM_DATE[YEAR]) VAR month_min = Min( VW_DIM_DATE[MONTH_ID]) VAR day_min= Min( VW_DIM_DATE[DAY_OF_MONTH] ) RETURN DATE ( year_min,month_min,day_min ) _NonClassificationSitesInDateRange1 = CALCULATE( DISTINCTCOUNT(VW_DIM_SITES[EXISTING_RESOURCE_ID]), DATESBETWEEN( VW_DIM_SITES[SITE_CREATION_DT], [MIN_DATE], [MAX_DATE] ) ) The last measure was put in table, but it doesn't work correctly. I have creation date from 2015 to 2023 years but it works only when the date range includes 2023 year. Could you please help me with this issue or suggest any other solutions?
Cant create relationship between Date and Calender[Date] .
now i have multiple tables CFS_Import , CFS_Export and CL now i have one more table name List , so i have created relationship between These three tables and the List table , now i when i create a new table named Calendar which contains only Date column , i want to link all the three table Date column with this column , so that when i drag this Calendar[Date] in any slicer it can act as a unified date slicer or when i drag it to x-axis of any line chart and add revenues of different table it will work 'fine , but i am only able to make relationship between one of the table and the rest two table's relationship turns inactive and when i try to turn it active it gives error for ambiguity.
