Forum Discussion
dax
Hi Anonymous
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.
| Category | Swing Sales | Month |
| Aircare | 37 | 7 |
| Aircare | 30 | 8 |
| Aircare | 28 | 9 |
| Aircare | 25 | 10 |
| Baby Care | 653 | 7 |
| Baby Care | 645 | 8 |
| Baby Care | 664 | 9 |
| Baby Care | 520 | 10 |
| Fabric & Home Care | 1210 | 7 |
| Fabric & Home Care | 1167 | 8 |
| Fabric & Home Care | 1019 | 9 |
| Fabric & Home Care | 1067 | 10 |
| Fem Care | 654 | 7 |
| Fem Care | 677 | 8 |
| Fem Care | 546 | 9 |
| Fem Care | 560 | 10 |
| Grooming | 436 | 7 |
| Grooming | 527 | 8 |
| Grooming | 472 | 9 |
| Grooming | 460 | 10 |
| Hair Care | 383 | 7 |
| Hair Care | 278 | 8 |
| Hair Care | 268 | 9 |
| Hair Care | 301 | 10 |
| Health Care | 841 | 7 |
| Health Care | 911 | 8 |
| Health Care | 673 | 9 |
| Health Care | 804 | 10 |
| Oral Care | 249 | 7 |
| Oral Care | 186 | 8 |
| Oral Care | 187 | 9 |
| Oral Care | 243 | 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 |
| Skin care | 20 | 7 |
| Skin care | 30 | 8 |
| Skin care | 28 | 9 |
| Skin care | 52 | 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
Hi Anonymous
Please provide data with date column it would be easier to calculate dax.Hi Anonymous
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.