Top "M" questions

How to Find the Most Current Date From a Column in Power Query - MAX()

This is for a Power Query: I am working on a report that compiles information from different dates and I …

powerbi powerquery m

How to use DATEDIFF in Power Query (M query) to look for months between two dates

I need to find the month difference between two dates (checkIn and Checkout dates) in Power Query (M-query). It can …

powerbi powerquery m

Subtracting row values in DAX ; Power BI

If I have data of this sort: I'd like to calculate the time difference between a value in Bi and …

powerbi m

Power Query -> Transform Comma to Period and Obtain Decimal Numbers

I'm working within Excel Query Editor (Power Query) and I have a table with many columns. Some of the numbers …

excel powerquery m

Visualizing last refresh date in power bi

Is it possible to add a card in power BI that shows the last time the underneath dataset has been …

data-visualization powerbi dax m

How to get paginated data from API in Power BI

Let's say we have this endpoint https://reqres.in/api/users. The response is { "page": 1, "per_page": 3, "total": 12, "total_pages": 4, "…

powerbi powerquery m

Get Current Workbook Path - Excel Power Query

Trying to add a custom column and populating the value with the current workbook path name. I have tried Excel.…

excel powerquery m