i have the following dax formula i need this formulas value to be divided to 20. As is the formula works good, i couldn't figure out to add in division to it. I
I am having a problem displaying a sum value in a gauge visual. My table has many rows with a value in each along with a date. I wrote a measure that calculat
I have been using Tableau for quite some time but am getting some new experience with Power BI and the use of DAX, and am wondering how I would go about recreat
I am using an ODBC driver of MarkLogic instance which I am using in Power BI to access MarkLogic database files. I am using 64 bit ODBC driver and have set up t
I have created a date table in Power BI called DimDate with fields, Date, Month (Month Name in Text Format), MonthNum (Month in numeric), MonthSort (Redundant f
I know that there are various questions related to looking up values in power bi. However, my question is related to looking up multiple values based on conditi
I'd like to make a visual with average amount (totalled per one or more teams) per month (while keeping date hierachy to show data per day). I have a table with
I'm attempting to calculate market share (percentage of total) for a segment after a user selects a specific product within a filter. Data looks like this: Dat
Has anybody got Podio to work with Power BI. I managed to get the token process to work in Power BI. I can get single record results to work but when using a li
It's my first time using this website, and I am a newbie with PowerBi, so apologies in advance if the question isn't clear. This is a quickly reproduced scenari
I have a specific hierarchy that I have developed: I was expecting it to be: level 6 ( )level11 ( )( )Account description level 3 ( )Account description But I
I have a table that lists a series of dates and a sales amount made on each date. So against each date, I would like to create two additional columns a)A curren
I need a little help since im new to PowerBI. I have a data set which says what have been eaten in a specific day. At the end there are columns which show if th
I have a tricky situation in Microsoft Power BI, and DAX language: I am developing a new Calculated Column called Status_CC in a table called Customers; we refe
Working on a stacked bar chart with PowerBi desktop up to 53 levels. Sometimes fewer levels, sometime more. Need to assign a color that is the same irrespecti
How to return DAX table based on a condition? The IF function cannot return a table in DAX. IF( 1=1, table_1, table_2 ) It raises an error: The expression refe
I made a measure that is as follows: wo = CALCULATE( DISTINCTCOUNT('Table1'[won]), ALLEXCEPT(Table1, 'Table1'[flag]), ALLEXCEPT(Calendar,Calendar[End of Week]),
is it possible to compare particular values from a table/report from power bi data set with another table from excel sheet? In the power bi data set i have the
I have dates like: I need to do two transformations: Convert it into datetime field date and time in the initial data shows in GMT. Necessary translate into ou
I am using Azure Logic App workflows to refresh a Power BI dataset every 5 minutes. The workflow was working for several weeks without any issues . But since la