Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the below example of a table in excel, and I want to create it on Power BI, knowing that I have all the monthly payroll runs for each company. But I am not sure how to apply the precentage change over each peroid:
Hi @basimretal
You can use "Quick measure" over Net amount as based value and pick "Month-over-month change" for calculation over Date(Has to be Date table) or create a DAX measure
% Monthly =
VAR _AmountPreviousMonth = CALCULATE(SUM(Net amount) , PREVIOUSMONTH(DATE_TABLE(COLUMN_DATE)))
VAR _NetAmount = SUM(Net amount)
VAR _Result = 1 - DIVIDE(_AmountPreviousMonth , _NetAmount, 0)
RETURN
_Result
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
There is no other way besdies Date table?
Best way is to add a Date Table to your model. do you have a problem adding it?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Is there a standard method to add a date table to the data module?
User | Count |
---|---|
89 | |
73 | |
68 | |
64 | |
56 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |