I have Month number as [Month], sales as Retailing , document_date and i want to display sales of last to last month. and another measure of sales prior to last to last month. These needs to be displayed in a matrix in with there are some other columns so i can not take month column in column directly.
first of all , You have to create calendar table and then connect with your table. That calendar table(Table name is calendar) structure below.
after you will create dax measure.
Would you please provide the expected output??
dont show the actual data just random data(but correct) in expected output just to get the idea how many columns would be there in matrix visual.
|Fabric & Home Care||1210||7|
|Fabric & Home Care||1167||8|
|Fabric & Home Care||1019||9|
|Fabric & Home Care||1067||10|
|Personal Care (GIL)||51||7|
|Personal Care (GIL)||51||8|
|Personal Care (GIL)||72||9|
|Personal Care (GIL)||51||10|
|Personal Care (OS)||13||7|
|Personal Care (OS)||16||8|
|Personal Care (OS)||19||9|
|Personal Care (OS)||14||10|
if you select 10 th month then i want to display 10th sales as well as 9, 8,7
expected result for 9th should be 3976 8th should be 4520. I dont want to add month in the matrix.
measures for last month then last to last month and prior to last to last. 3 measures. i do have document_date as date column but if you can do it with just month that would be gr8. @Uzi2019
Please provide data with date column it would be easier to calculate dax.
Please provide the expected output in form of matrix visual. you can calculate in excel share the that table here to understand how you want to see the data.
how much data will be there when you want to display in table visual.
I hope you know what I am asking.
i have sales of last year, this year , i have shown last month also but i'am not able to show last 2 last month and before that. these data should change dynamically whenever i select a month then these should change automatically rather than manually entering month for each measure.
Based on your data for 7,8,9,10 as month Number.I have created simple formula
I hope this is what you are looking for
if you select 10 in slicer then 7,8,9,10 should be calcualted.
If I select 9 then 7,8,9 data should be summed up. because you have limited data.
Please create below measure for last 3 months calculation:
I hope this is what you wanted.
and If you want something like below image then its different calculation!
Based on your selection your measure should change the value.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.