Most RecentNewestMost VotedMost ViewedRolling calculation for previous 12 months I have a cumulative hours (last 12 months) caculator DAX as follows: Cumulative HOURS = CALCULATE( SUM('Unit'[Hours Worked]), DATESINPERIOD('Unit'[Month], LASTDATE('Unit'[Month]),-12,MONTH )) This will give me the cumulative value for last 12 months, say June 2021 to May 2022. I now want to plot this agaist cumulative of previous 12 months, that is July 2020 - June 2021. How should I modify DAX to get these values. I want both line graphs in the same plot for comparison. How do I go about doing that? Thanks in advance! SolvedExtracting a number from TextHi everyone :), I have a column with texts such as " XXXX P10000 FFFFF" , "ABCD R150000" would you please help me to find a formula to extract the 10000 and 150000 after the P and R. They are always either P or R as the begining. Thanks alot.
