Power BI: Replace column values with conditional value using Power QueryBelow is the syntax and example of a Power Query to replace columns values with an another value or a conditional value derived from other…Dec 17, 2024Dec 17, 2024
Power BI: “Make changes to this Model” option unavailableWhen you connect to the Power BI dataset, there should be an option in the status bar showing that you are connecting to the Power BI…Jun 6, 2023Jun 6, 2023
MS Access: Update table with subqueries including multiple joinsIn order to update a table with data joined from other tables, use a query with following syntaxJun 26, 2021Jun 26, 2021
Power BI: How to connect with MS Access as data sourceIf you are using the Power BI 64-bit Desktop and connecting to MS Access, install 64-bit database engine from Microsoft link below.Jun 26, 2021Jun 26, 2021
Power BI: Conditional formatting based on field with color valuesAssuming you have a table with a field that has color values as shown in below example, then the color value field can be used to apply…May 17, 2021May 17, 2021
Power BI: Difference between ALL and ALLSELECTED in CALCULATEALL will ignore all the filters inside and outside the queryMay 7, 2021May 7, 2021
Power BI: How to convert columns to rows (unpivot or convert wide to narrow) table dataFollow the below instructions to convert columns to rowsMay 7, 2021May 7, 2021
Power BI: Concatenate multiple textsBelow shows how to concatenate multiple texts in DAX in Power BIFeb 17, 2021Feb 17, 2021
Power BI: Setting Blank DateWhen you have condition, where you want set a date field to blank or date depending on the condition, the following formula will work.Oct 1, 2020Oct 1, 2020
