I'm wanting to filter a table, let's call it "Capitals," indirectly based on a slicer value. Here's an example looking at capital cities: Current_Name Prior_N
Hi I have desperately been trying to work this out and have referred to several posts but am still not getting the correct answer! I have a bunch of providers o
I have created a measure using userelationship and crossfilter measure is working fine I put this on some visual and applied RLS. I have published this on my wo
I need to build a student cohort tracking pbix so as to show students who have progressed onto the next consecutive year, students who have continued their stud
I currently have a code that changes date to local time by adding 3h to current time. =Format(DateAdd("h",3,Now()), "dd.MM.yyyy hh:mm:ss tt") & " EET" This
I have financial data from various companies. For company A data is provided as YTD values, for company B data is provided as monthly values. This can be seeen
I'm messing around with Visualization in Power BI and cannot find the chart I'm looking for. Use a dataset pertaining to the 2020 CDC Heart Disease study, I've
I am new to Power BI.I have one year filter (Range filter) and one week number filter (Range filter). I want to calculate values such that when i select year 20
I have a csv file with 3 rows of data which is stored in Marklogic and available in collections. I am trying to access the content of the csv file from Power BI
I am trying to roll up a table in DAX as seen below. It's just some operations. I can do this in SQL with joins or in Power Query with merges or pivots, however
I don't think this is doing what I want it to do. I have a fact table with columns date, weekstarting, customer, product and qtyshipped and I want an average pr
I have spent hours trying to solve and I dont' even know what to search an answer for: This is my base data table in Power BI PA PA FTE PERSON PERSON FTE Anne
I have a matrix visual where I am showing different different measures across multiple year. I am not able to use expand/collapse option in power bi if I am usi
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