Skip to main content

Catogorizing Last 30 Days, 60 days,90 days in Power bi

Link to Video Tutorial -> https://www.youtube.com/watch?v=hDopw1mPlrU

 Step-1 ->Create a seprate calulated table as shown below

Period = 
VAR
    _last30days = ADDCOLUMNS(
        CALCULATETABLE(
            'Calendar'
            ,DATESBETWEEN( 'Calendar'[Date], TODAY() - 30, TODAY() )
        )
        , "In the last", "30 days"
    )
VAR
    _last60days = ADDCOLUMNS(
        CALCULATETABLE(
            'Calendar'
            ,DATESBETWEEN( 'Calendar'[Date], TODAY() - 60, TODAY() )
        )
        , "In the last", "60 days"
    )
VAR
    _last90days = ADDCOLUMNS(
        CALCULATETABLE(
            'Calendar'
            ,DATESBETWEEN( 'Calendar'[Date], TODAY() - 90, TODAY() )
        )
        , "In the last", "90 days"
    )
RETURN
    UNION( _last30days, _last60days, _last90days )


Step-2 --> Crate a bidirectional Link to Calender and period table






Comments

Popular posts from this blog

Convex Lens Vs Concave Lens

What is a Lens A lens is a transparent object that transmits light across it, and its working principle depends on the   law of refraction (Snell’s law) . Applications: Concave Lens help with Far-Sight Convex Lens help with Near-Sight

Herbal Plants

Herbal plants to grow in home Different types of keerai ----- http://www.indiandietrecipes.com/2016/03/pictures-of-various-types-of-greens-or.html Pirandai ----good for bone joins---- https://youtu.be/k2DGubyXLAE Valarai Keerai Benifits ----- https://youtu.be/33HIfLJKTqA Sesma seeds ---- https://easyayurveda.com/2011/02/24/sesame-and-sesame-oil-benefits-total-ayurveda-details/

What is Verbal and Non-Verbal communication

TYPES OF COMMUNICATIONS: