subtraction of row
2 TopicsSubtracting row wise value from same column and showing the result as difference in new column
Hi Team, I have a table consisting of Fiscal year FY20 and FY21(both FYs starts from July) and for that I have count of employee ID column next to it... Now I want to subtract count of empid for FY20 from FY21 without hardcoding the FYs in DAX. In future if FY22 comes then the subtraction should happen from FY21 to FY22..And so on I have used EARLIER function but no luck yet. Please help me if something can be done in such caseSolved3KViews0likes21Comments