Hi v-tianyich-msft,
thanks your response. I have unpivotted and selcted only the months i need. I was able to calculate as well
Rolling 6M Next =
CALCULATE(
SUM('_Fact_'[Value]),
DATESINPERIOD(
'DateTable'[Date],
TODAY(),
6,
MONTH
)
)
and
Rolling 12M Revenue =
CALCULATE(
SUM('_Fact_'[Value]),
DATESINPERIOD(
'DateTable'[Date],
TODAY(),
12,
MONTH
)
)
The issue is how to categorize this data based on my conditions, when i tr something like that: Company Size Category =
VAR Rolling12M = [Rolling 12M Revenue]
VAR Rolling6M = [Rolling 6M Next]
RETURN
SWITCH(
TRUE(),
Rolling12M > 2000000, "L",
Rolling12M >= 500000 && Rolling12M <= 2000000, "M",
Rolling6M < 500000, "S",
Rolling12M < 500000, "XS",
"Uncategorized"
)
VAR Rolling12M = [Rolling 12M Revenue]
VAR Rolling6M = [Rolling 6M Next]
RETURN
SWITCH(
TRUE(),
Rolling12M > 2000000, "L",
Rolling12M >= 500000 && Rolling12M <= 2000000, "M",
Rolling6M < 500000, "S",
Rolling12M < 500000, "XS",
"Uncategorized"
)
I see only M and S, however if i add dates to rows, i can see there are should L categories.
An ideas? Thanks in advance!"
Helpful resources
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
