Power BI DAX

Power BI notes

Posted by John Liu on Friday, December 23, 2022

Number formatting

“#,0.00” two decimal with thousand separator

“#,0” no decimal with thousand separator

“#,#” no decimal with thousand separator

“P0” no decimal point

“P2” 2 decimal points

Workout the first day of the week based on sepecified day

=DateAdd(DateInterval.Day
    ,1
    ,DateAdd(DateInterval.Day
            ,DatePart(DateInterval.WeekDay
                    ,iif(IsNothing(Parameters!ReportDate.Value),Today(),Parameters!ReportDate.Value)
                    ,FirstDayOfWeek.Sunday
                    )  * -1
            ,iif(IsNothing(Parameters!ReportDate.Value),Today(),Parameters!ReportDate.Value)
            )
    )
FEATURED TAGS
ai api automation azure azure cosmos db azure openai azure vm base64 dax docker excel execution plan hyper-v infrastructure m machine learning machine learning services network network card performance power automate power bi power bi report tricks power query powershell python qgis query performance regex replication snowflake sql sql script sql server sql server admin sql server config ssl ssms troubleshooting unicode vmware