Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need help calculating the percentage change from the previous months and quarters.
I know of the two formulas previousmonths and previousquarter. However, I can't make it work...
I have five different numeric values, let's call them:
A, B, C, D, E
Then I have a Date_Snap_key, let's call it:
Date_1
Can anyone be of help regarding this issue.
The dates are not only on monthly basis - they are daily... Also, I can´t call the month measure as it won't let me select the measure ´closing balance´...
Hi,
Just to give you an idea of what I have, I have provided a table below...
I have around 3000 rows, so I couldn't provide it all
Closing balance | Date |
1400050 | 07 December 2020 |
5889910 | 20 December 2020 |
1588392 | 23 april 2021 |
1999993 | 09 November 2021 |
Hi @veakin ,
Please have a try.
Create an index. Select Home >>Transform Data>>Add column>>Insex column>>From 1.
Then close and apply.
Create measures.
next_date = SUMX(FILTER(ALL('Table'),'Table'[Index]=SELECTEDVALUE('Table'[Index])-1),'Table'[Closing balance])
month = var diff = SELECTEDVALUE('Table'[Closing balance])-[next_date]
var month_=DIVIDE(diff,SELECTEDVALUE('Table'[Closing balance]))
return month_
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Polly
Hi @veakin .
Please provide some data and desired output.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Polly
Yeah I have this column:
This is what I have:
But my value columns is measures.. that's why its triggy...
I know of the two formulas previousmonths and previousquarter. However, I can't make it work...
Do you have a calendar table with "Mark as date table" Built in time intelligence functions require that to function? If you already have that done, can you share the DAX you are struggling with?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |