PinnedNilantha KM·Sep 23, 2025How to set up a dynamic month name sorting axisSuppose we have a chart as shown in Figure 1. The Y-axis is Total Sales, and the X-axis is Month Name. We have a requirement that the…
PinnedNilantha KM·Sep 24, 2025Exploring the RANKX DAX function in Power BISuppose we have sales data as shown in Figure 1, a data model as shown in Figure 2, and we need to display the top N product brands based…
PinnedNilantha KM·Sep 18, 2025How to calculate total revenue using an inactive relationship in DAXSuppose I have a data model as shown in Figure 1. The Calendar table is the dimension table, and the Sales table is the fact table. Here…
PinnedNilantha KM·Sep 18, 2025How to calculate the last N dates of sales in Power BI DAXSuppose we have a Power BI data model as shown in Figure 1. And we need to calculate the last N dates of sales. The “Total sales” measure…
PinnedNilantha KM·Sep 23, 2025Practical usage of SELECTEDVALUE DAX functionHere is the official explanation of the SELECTEDVALUE DAX function
Nilantha KM·Nov 18, 2025TOTALYTD() VS DATESYTD() in Power BIIn this article, I’m aiming to answer these key questions.
Nilantha KM·Oct 31, 2025How RELATED and RELATEDTABLE work in Power BILet’s consider a scenario where we’re working with Sales, Products tables, and a data model as shown in Figures 1, 2, and 3.
Nilantha KM·Oct 7, 2025Exploring the SUM, CALCULATE, FILTER, and VALUES Functions in Power BI DAXSuppose we have a data model as shown in Figure 1. And I have calculated two measures as follows.
Nilantha KM·Sep 26, 2025Spotting Highs and Lows in Sales Trends(In a Power BI line chart)Suppose we have a sales dataset. We can visualize the sales values by region, as shown in Figure 1.
Nilantha KM·Sep 25, 2025Cumulative Totals in Power BI: Why the ALL DAX Function MattersSuppose we have a table as shown in Figure 1, and we need to calculate the running total or cumulative total.