Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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.5k points)
0 votes
1 answer
0 votes
1 answer
asked Dec 21, 2020 in BI by Chris (11.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...