Forum Discussion

BratKat's avatar
BratKat
Microsoft Employee
3 years ago
Solved

Concatenate columns when calculating

Creating a Slicer for weeks and this works if I only use DATE  Working  Slicer2 = var _start_date = CALCULATE(MIN('Work Items'[Team Date 01].[Date]),FILTER('Work Items','Work Items'[weeknum]=EARLI...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi BratKat ,

    Is it possible to try to bring up the year?

    Like this:

    Fiscal Quarter =
VAR _1 =
    IF (
        'Work Items'[Quarters] = 3,
        1,
        IF (
            'Work Items'[Quarters] = 4,
            2,
            IF ( 'Work Items'[Quarters] = 1, 3, IF ( 'Work Items'[Quarters] = 2, 4 ) )
        )
    )
VAR _2 =
    YEAR ( table[date] )
RETURN
    _2 & " " & _1

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BratKat's avatar
BratKat
Microsoft Employee
3 years ago

The slicer returned works however there is no year listed only the Fiscal quarter and our data starts last October, so trying to denote which year the quarter is showing.