Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to understand why when I use SELECTEDVALUE and MAX the columns from Calendar table is being duplicated by each "Month Name"
MAX:
SELECTEDVALUE:
Normal view :
Relationship:
I'm trying to calculate on each row the amount of revenue from the begining of the FY & Q column.
Hope you can help me.
Thanks.
Solved! Go to Solution.
Whoops, sorry, I missed that. Give this a try:
__TEST =
VAR _Quarter = SELECTEDVALUE ( 'Calendar'[FY & Q] )
VAR _Start = CALCULATE ( MIN ( 'Calendar'[Date] ), ALL ( 'Calendar' ), 'Calendar'[FY & Q] = _Quarter )
RETURN
CALCULATE (
[_Actual Rev],
DATESINPERIOD ( Calendar[Date], _Start, 1, MONTH )
)
Hi,
Please try this, generate the month number first and the use this, depending on you FY start date. This is for an year running July to June
Whoops, sorry, I missed that. Give this a try:
__TEST =
VAR _Quarter = SELECTEDVALUE ( 'Calendar'[FY & Q] )
VAR _Start = CALCULATE ( MIN ( 'Calendar'[Date] ), ALL ( 'Calendar' ), 'Calendar'[FY & Q] = _Quarter )
RETURN
CALCULATE (
[_Actual Rev],
DATESINPERIOD ( Calendar[Date], _Start, 1, MONTH )
)
Try it with time intelligence rather than string matching.
__TEST =
CALCULATE (
[_Actual Rev],
DATESINPERIOD ( Calendar[Date], STARTOFQUARTER ( Calendar[Date] ), 1, MONTH )
)
Hi @jdbuchanan71 ,
It doesn't work with time intelligence because is FISCAL QUARTER and not regular/Calendar Quarter.
The Year Starts in September, not in January. so Same criteria for the quarters
Fiscal Period:
Fiscal Quarter:
Regards.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |