SPLY with Multiple Date Columns
I have Service Date Column and Paid Date Column that might occures 3-6 month after the service date. So for instance I need to filter the dashboard 12 months of service and 15 months of Paid, How can I apply SPLY to the both [svc date] and [paid date] in a calculated measure [INVOICE] in a new measure! VAR _SVC_MAX_DATE = MAX('SERVICE CALENDAR'[Date]) VAR _SVC_MIN_DATE= MIN('SERVICE CALENDAR'[Date]) VAR _PD_MAX_DATE = MAX('PAID CALENDAR'[Date]) VAR _PD_MIN_DATE= MIN('PAID CALENDAR'[Date]) RETURN CALCULATE([INVOICE],SAMEPERIODLASTYEAR('INVOICE'[SVC_DT]),'INVOICE'[CLM_DT]>= _SVC_MIN_DATE && 'INVOCE'[SVC_DT] <= _CLM_MAX_DATE) Thanks!
Calculating Last Year Issue
Hi again. Having an issue with my LY cacluation. I have data in the matrix from 2020-2023 and need to see LY's results number in a column for each year. The below calculation is carring the same number for each year. I have tried various built in calculations, but I end up with no data in my column. I am sure I am missing something simple...thanks in advance.
Calculate YTD and YTD-1 for the same period
Hello, I would like to calculate the YTD Spend and the YTD -1 Spend for the same period. For example for 2021 we are in October so I would like to calculate the Spend for 2020 only until October. For the moment I have created this formula : Spend YTD-1 = CALCULATE(SUM('Spend consolidé'[Invoice_Accounting_EUR]),SAMEPERIODLASTYEAR('Calendar'[Date])) But it's not working, when I filter on 2021, with this formula I have the spend for the entire year of 2020 instead of having until October. Any advice to help me solve my problem ? Thanks, AxelSales last year, same week number, same day
Hello there, I am currently having current year sales and have a measure calculating last year sales. However, it is looking on the same day last year increments but I am more interested in looking in the same week number, same day number (so if it is week 42, Monday, to look last year in week 42, Monday). I have managed to get the correct sales per day by creating a new collumn like this : DayWeekYear = ([UgedagNummer]*100+ [UgeNr])*10000+[År] and then a measure like this : Oms. kr. SÅ try = CALCULATE(SUM(F_Butikssalg[Oms]),FILTER(ALL(D_Periode),D_Periode[DayWeekYear] = MAX(D_Periode[DayWeekYear])-1)) BUT, this works only on a day level visual. If I want it displayed as a cummul of all values in a week or years and filter a longer period, it will not take all sales per specified period but rather print a value for one day. Oms is current sales. Oms. kr. SÅ is the current measure matching the same day last year (ex. 16 Oct with 16 Oct) and Oms. kr. SÅ try is last year sales taking into account week and day number( day number is : Monday=1; Tuesday=2.....Sunday=7) I want when selecting sales last year to have them dispayed looking on the same week number and day number on all levels of visualization and filtering: day/week/month/year. I have tried making the same column only with year&week but then I cannot get sales last year per day and if I create one visual and select multiple week, if i have weeks display I get correct amounts but not total and if i want only a total for filtered weeks i get again a wrong number. Majority of connection in the datamodel for date are made through D_Periode using Dato which is format as dd/mm/yyyy Thank you in advance.Slicer to show Current Week by default
HI everyone. I want to show Current week as default when user open the report or changes the report page. I want this slicer to show by default whenever user opens the report or changes the report page. when user come backs to the page it should show the sales by current week. PFB the dax im using currently to show the current week between the weeks, //Current Week Slicer IF(DMVBICalendarView1[SemCourante]= "courrante", "Courante", IF(DMVBICalendarView1[SemCourante]= "courrante-1", "Courante", IF(DMVBICalendarView1[SemCourante]= "courrante-2", "Courante", IF(DMVBICalendarView1[SemCourante]= "courrante-3", "Courante", //Merging DMVBICalendarView1[Semaine Fiscale] &"-"& DMVBICalendarView1[Semaine 2022])))) Need your help. Thanks in advance.Sameperiod Lastyear Issue
Hi everyone I have some issue about function sameperiodlastyear, I want to compare data between present year and last year value by using sameperiodlastyear, for whole data is ok, but when i filter select some product, i found my date data is not continue because "The relationship between date table and data table is both relationship " then the function is not calculated, so i try to solve with crossfilter function to "active single relationship" but it won't work. Could anyone can suggest solution for this issue?
