Forum Discussion

Hemant_Jaiswar's avatar
Hemant_Jaiswar
Icon for Helper I rankHelper I
1 year ago

aggregation at customer name level

desired output  Month Total 2023 Total 2024 LFL 2023 LFL 2024 Jan 20 35 20 27 Feb 21 31 21 22 Mar 20 37 20 28 Apr 32 33 12 33 Goal: Total 2023: Sum the...
Need Help
Show and Tell
Tips and Tricks
Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

Hemant_Jaiswar 

Use the following DAX measures:

Total 2023 = SUM('Table'[2023 Sales])

Total 2024 = SUM('Table'[2024 Sales])
LFL 2023 = 
CALCULATE(
SUM('Table'[2023 Sales]),
FILTER(
'Table',
NOT(ISBLANK('Table'[2023 Sales])) &&
NOT(ISBLANK('Table'[2024 Sales]))
)
)
LFL 2024 = 
CALCULATE(
SUM('Table'[2024 Sales]),
FILTER(
'Table',
NOT(ISBLANK('Table'[2023 Sales])) &&
NOT(ISBLANK('Table'[2024 Sales]))
)
)

Create a table visual with Month as rows and the four measures as columns.