Relative Content

Tag Archive for powerbidaxpowerbi-desktop

Power BI – Average Daily Data

I have the attached excel spreadsheet which I have loaded into Power BI, I am trying to create a graph with
average time by month but can’t figure it out! How do I do this please?
The first column has data by day and the second column has a time every day. I need to average these out by month.

Power BI get the last NR using DAX

I have two tables.
First table with duplicate material numbers and an ‘NR2’ Column
and the second table with only 1 material number and also an ‘Nr’ Column.

Conditional Cumulative Sum in DAX

I am transferring an Excel report to Power BI, and I have a data field called ‘Position’ that is evaluated every month. For the current month, the position remains unchanged. However, for the next month, it will be calculated as follows: if the current month’s position is negative, it will be the sum of the next month’s position and the current month’s position. If this sum is still negative, in the third subsequent month, the position will be the result of the third month plus the sum of the second month. Each Excel cell follows this formula: