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
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
