Search results

Without the data model structure and bit of sample data, but hard to help. Though my guess, would be SUMX() that's your issue. SUMX is evaluated in each row context. From what I see in your screen shots. You don't need SUMX but just SUM([Recharge Value (Tiered) OLD])

In calculated columns, everything is evaluated based on row context. I'm assuming there's relationship between the table. Though without knowing your data set, and model. Bit hard for me to give you exact answer. Personally, I'd do this sort of calculation in DAX measure. But it will depend on...

You need to override filter context of the visual. Since it's segregated to "Aug" that's limiting the scope. You'll need to use ALL() and apply your condition using FILTER() function.

Typically speaking. You don't perform this sort of calculation in DAX column. What's your end goal?

PQ isn't the right tool. The site uses Ajax query once you navigate to venueUnitID URL. Ajax query URL is as following. "https://www.handball.no/AjaxData/SortedMatchesReservationsForVenue?fom=08.01.2024&tom=07.01.2025&id=4425&_=1725887420106" However, URL alone will not fetch the data...

Can you specify what you mean by "Heading"? If you mean visual title. You will need to overlay another visual (ex: Card visual) and use CONCATENATEX etc to construct measure to build string for title. See link for basic tutorial...

How are you using your measure? Context of DAX measure evaluation is critical in order for us to help you. But why do it in measure? That's column transformation type operation and best done in PQ stage. Not in data model using DAX. What is your end goal?

Try using Table.Buffer() to speed things up. Though mileage ma vary by machine spec. If wanting to do it in DAX either as calculated column or using measure. Have a read of link. https://www.sqlbi.com/articles/introducing-rankx-in-dax/

First extract month/monthname from date. Assuming it's actual Date type. =Date.Month([Date]) Select Custom, Group By, All Rows (No aggregation). Add custom column (Assuming original table is unsorted). =Table.AddIndexColumn(Table.Sort([Temp],{"Date", Order.Descending}), "Rank", 1) Remove all...

Load data to PQ. Then in the editor, select Plan Qtr & LE Qtr. Then unpivot. Load data to data model and make pivot table using data model as source. That's pretty much it.

You need to flatten data. Meaning Qtr data should be single column and another column for LE/Plan.

First, start by flattening out all your tables. But how is 1st table supposed to relate to the other 2? At any rate. Add custom column to Revenue & Expense after flattening it out. Change "Revenue" to "Expense" for Expense table. = Table.AddColumn(#"Renamed Columns", "Type", each "Revenue"...

There are tools to audit/evaluate your model, DAX pattern etc. SQLBI has many useful tools. https://daxstudio.org/ https://www.sqlbi.com/tools/bravo-for-power-bi/ https://www.sqlbi.com/tools/vertipaq-analyzer/ Other tools that I use are mostly for PowerBI Service or for Embedded. And doesn't...

This is forum for Power tool stack (Power Pivot, Power Query, Power BI etc). What you have is standard pivot table. You can't do that sort of Avg operation in traditional pivot. Source data granularity must match that of your Rows field. Meaning you need source data aggregated at daily level...

In your sample Sr. no 1 on either side isn't exact match. In PQ, text comparison is case sensitive. At any rate, see below for issue with your data set. Note that you can't mix FuzzyNestedJoin with regular join. Join type is defined at table level and not at column level. If it's inner join...

If they access via PowerBI desktop. That's not going to hide data from users. They will be able to see everything that's in the model. I'd recommend alternate approach. Such as leveraging Power Automate and Power Apps to serve data to the user.

It all depends on how underlying data is modeled and what fields belong to which table etc. Without data model, relationship and your actual measure(s), it's very difficult to give you help. I'd recommend uploading sample workbook that replicates your issue with desensitized data.

Go read up the link I gave you. It discusses in detail what caused this issue. As for difference between Fact vs Dimension tables... see links. https://builtin.com/articles/fact-table-vs-dimension-table https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

Well... you don't have any value field to evaluate. Just add some field from T_Leases in Value field (Ex: Count of Agent etc). Have a read of related topic discussed in link. Specifically Post#11 to 17. https://chandoo.org/forum/threads/power-pivot-relationships-failed.38779/

DAX is contextual and will return different result based on what context it's evaluated on. Measure is evaluated within visual's filter context. Where as calculated column is evaluated on each row's context.

What's the point of this? As long as input is different A~F. It will always return Undefined... At any rate, values creates nested list with each list row containing pair {"A", "Apple"} etc. List.Select iterates over the list and looking at first list element in the nested list to see if it...

... there still is no data model or how your schema is structured or columns related in the model...

Please read link and update your title to be more descriptive of your actual question and explain it in the body of the post. This will allow search engine to find your question and help future users to benefit from solution provided...

Too generic of question and your sample is of no help. At any rate, in PowerBI you'll only have commenting function only at visual and report level. Not at data level. For that, you'll need some sort of 3rd party service/plug-in.

@Rameez Sarang Your issue is that you are asking DAX/Data model related question. Yet, your file only contains flat list. With no data model or schema. DAX is highly contextual in it's nature and will evaluate differently based on context it's evaluated on. Without knowing your data model...