Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dimension in Bar Chart

Hi, I'm trying to reach the following objective: Table 1 Date region count 01/11/2018 region1 100 01/11/2018 region2 20 01/11/2018 region3 30 01/11/2018 region4 15 01/1...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , You have create a new column like

     

    New Region  =

    switch(true() ,

    [region] in {"Region 3", "Region 4"} , "Region 3 & 4",

    [region]

    )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Here is the dax for the previous month calculation. How to incorporate your proposal for the dimension?

Total last Month =
CALCULATE (
SUM ( table[total] ),
table[region] IN { 1, 2, 3, 4, 5 },
DATESBETWEEN (
'Date'[Date],
EOMONTH ( TODAY (), -2 ) + 1,
EOMONTH ( TODAY (), -1 )
)
)