Circular Dependency on Power BI, when Couple Measure depends on each other
I have a problem when I create measure
Power BI – Create Date table with corresponding text column
I’m trying to create a date table with a corresponding text column for each date. Like in the table below.
In Power BI, how can I create 7 day buckets that are calculated dynamically from the selected date in a date filter?
I am working on a Power BI dashboard where I need to create a bar chart that shows 8 bars for the last 8 weeks. The first bar from the right, shows the last 7 days and every next bar the 7 days before that. This should be dynamically changing based on the selected date.
Power BI KPI Visual
In PowerBI Desktop, I have a KPI measure in which I am wanting to compare, for example, total number of items sold this month up until today, to total number of items sold last month up until todays date but I am struggling with what to return in DAX for last month up until todays date.
Concatenate sales month names in DAX
Using the AdventureWorks dataset, I need to create the following report in Power BI: First column has CustomerKey, second column Total Sales of this customer, and third column the distinct concatenation of the names of the months when that customer made a purchase.
increase the length of the error bar in powerbi
I am trying to make a chart to compare previous and current amount but the data is in weeks so the changes are so small. is there a way to extend the error bar line in power bi ? many thanks in advance.
custom formating in DAX
I need to add green down arrow
and red upper arrow
in my dax code. it seems to me there is no UNICHAR
option in here. many thanks in advance.
How to find the last date of each quarter in DAX
How to find the last date of each quarter When fiscal year starts from May, in DAX.
Running total even after changes
I currently have a table with rows containing mistakes made by employees in forms they fill out. The table was created using DAX, instructing it to pull rows from the main form-submission dataset meeting a specific criteria, with the columns FORMID, EMPLOYEE, MISTAKE CODE and MISTAKE DESCRIPTION.
In PowerBI, how to calculate column values?
I have two tables Table1
& Table2
, relationship between these tables is many (Table1
) to one (Table2
). This is the structure & sample data of the tables