The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello!
I need to create a calulated column "NEW COLUM", placing the last month values acording to the "tipe" column,
and olny the last month f.e I had 2700000 kg of CPRS in January, i need the same value for fabruary
I will appreciate someone´s help
Thanks
Solved! Go to Solution.
Try like this:
= CALCULATE(
SUM( 'Table'[kGS] ),
ALLEXCEPT( 'Table', 'Table'[Type] ),
'Table'[Month] = EARLIER( 'Table'[Month] ) - 1
)
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
You'll need a date table to do this properly. Then the following measure will give you the previous month sales. The filter context of the table/matrix will keep it to just items of the same Type.
=CALCULATE( [Total Sales], PREVIOUSMONTH('Calendar'[Date]) )
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingTry like this:
= CALCULATE(
SUM( 'Table'[kGS] ),
ALLEXCEPT( 'Table', 'Table'[Type] ),
'Table'[Month] = EARLIER( 'Table'[Month] ) - 1
)
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Can someone explain how the post marked as a solution works? My understanding of EARLIER is it has nothing to do with dates, but with contexts within a measure.
When I tried the measure marked as a solution, I get the following error, which is similar to what I expected.
Calculation error in measure 'SalesData'[measure 1]: EARLIER/EARLIEST refers to an earlier row context which doesn't exist.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting
you're probably using it in a measure which has no row context instead of a calculated column as the OP requested:
"
Hello!
I need to create a calulated column "NEW COLUM", placing the last month values acording to the "tipe" column,
and olny the last month f.e I had 2700000 kg of CPRS in January, i need the same value for fabruary"
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Ahhh... thanks. I never create calculated columns unless I need it in a measure, and even then, I tend to push it back to Power Query, so my bias there missed that part of the question. 🙂
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
107 | |
87 | |
65 | |
60 |
User | Count |
---|---|
257 | |
121 | |
117 | |
100 | |
79 |