Forum Discussion
Change in Month to Month
Hi Anonymous
Check if your column's data types are correct.
Check if your measures have correct spelling.
Try to put your measures into matrix in correct way. I tried to do this and managed to create something like this:Hi Anonymous
I've uploaded the test pbix file: https://filetransfer.io/data-package/ltRlwarj#link
You can check how I did it.Hi Anonymous ,
Please refer this formula:
Measure = VAR pre_month = CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALLEXCEPT ( 'Table', 'Table'[Lane], 'Table'[Attribute] ), 'Table'[Index] = SELECTEDVALUE ( 'Table'[Index] ) - 1 ) ) RETURN SUM ( 'Table'[Value] ) - pre_monthPbix as attachement.
Best Regards,
Jay
Resolver IIIHi Anonymous
You can try to do this like this:
1. In your table create a date column. I see your index column is basicly your month number. Find the year using this calculated column:
Year = LEFT(YourTable[Attribute], 4)
Then create the date column:
Date = DATE(YourTable[Year], YourTable[Index], 1)
2. Create the time table. You can use the CALENDARAUTO function.
3. Create relationship between your time table and a date you just created.
4. Create a measure to sum your value:
Sum of value = SUM(YourTable[Value])
5. Create measure to count last month value:
Sum of value last month = CALCULATE([Sum of value], PREVIOUSMONTH('YourTimeTable'[Date])
6. Count the difference using measure:
Diff Value to Last Month = [Sum of value] - [Sum of value last month]
Hi Saap Anonymous
I have a small problem now. When I select 2different in slicer it is taking it as combined one. How can i get the 2 different graphs. Can any of you please help me? 3 and 4 should be represented in the form of 1 and 2 but it is showing them as combined one.