The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
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 |
---|---|
137 | |
110 | |
106 | |
75 | |
62 |
User | Count |
---|---|
270 | |
129 | |
123 | |
100 | |
92 |