Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

How can I create Quater to date measure through fiscal calendar

QTD =
CALCULATE (
    [Total Amount],
    FILTER (
        ALLEXCEPT ( 'Calendar', 'Calendar'[FiscalYear] ),
        'Calendar'[FiscalQuarter] = MIN ( 'Calendar'[FiscalQuarter] )
            && 'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
    )
)

And this particular formula is not working and how can i resolve this 

1 Answer

0 votes
by (22.5k points)

Change the code into the following code

CALCULATE(
 [Total Amount],
 FILTER(
   ALL( 'Calendar' ),  
   'Calendar'[FiscalYear] = MIN( 'Calendar'[FiscalYear] )
     && 'Calendar'[FiscalQuarter] = MIN( 'Calendar'[FiscalQuarter] )
     && 'Calendar'[Date] <= MAX( 'Calendar'[Date] )
 )
)

If you want to learn more about Power BI, then read the Power BI Tutorial. Also, enroll in Power BI online Training to become proficient in this BI tool.

Related questions

0 votes
1 answer
asked Nov 30, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Nov 4, 2020 in BI by Sudhir_1997 (55.6k points)
0 votes
1 answer
0 votes
1 answer
asked Dec 21, 2020 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...