User Profile
Srinivas3350
Helper II
Joined 3 years ago
User Widgets
Contributions
Please need an urgent in DAX on growth with Current fiscal months and previous year fiscal months
Hello, I am stuck with 1 issue for a long time. I have attached screen shot below so the issue is i am showing revenue by month wise if i select another year it will show revenue of that year and in last year column it will show last year revenue of whatever year we select and in the margin column it is just margin-last year. so now if you see in the below screenshot the previous year revenue is for 2022-january is 3715 and so on.... in another table but if you see in the above screenshot the last year is showing 4109 the issue is it is calculating the current periods with last year periods example this year fiscal month jan started on 2nd and ended on 27th but in 2022 it started on 3rd and ended on 28th so it should with this periods but it calclating with all previous year with current periods.. can anyone help me please. this is the DAX i am using calculate last year revenue Last year = CALCULATE([Margin sum], DATEADD('Dim Time'[Full_Date],-1, YEAR))Need Urgent help in calculating with slicer selection
I am having requirement that i need to show resepective of my selection in the slicer it needs to show previous FC example lets say we have Forecast 11 which is FC11 so when ever i select FC11 in the slicer the top table should show same values for FC11 but in the bottem table It needs to show FC10. can anyone help how to acheive this with a measure or however you suggest. Thanks srinivascan anyone help me in YOY growth by Monthly
AS i AM HAVING YoY growth table with fiscal calender where iam using this measure ASP Growth = VAR CY = [REV] VAR LY = CALCULATE( [REV], DATESBETWEEN('Table'[DATE], EDATE(MIN('Table'[DATE]),-12), EOMONTH(MAX('Table'[DATE]),-12) ) ) RETURN CY-LY but it is not accurate for all months i have pointed some major differences it should calculate current year month - PY month i dont what is the issue for some months the values are not accurate i am using fiscal calendar. can anyone help me this is an urgent for meNeed a urgent help in DAX for calender
I am having a calender where the last friday of the month is end of the month so i am using some DAX to show current month filter in some reports but oct 27th is the last day of the month end and from 28th oct should come in november. I am using a DAX where it is showing current month untill 31st oct. can anyone help me please. CurrentMonthFlag_v1 = VAR CurrentYYMM = FORMAT(TODAY(), "YYMM") RETURN IF('DATE'[Fin_YYMM] = CurrentYYMM, 1, 0) Thanks Srinivas
