PowerPivot for Excel

When do you use ISFILTERED Function (DAX)?

In our daily office work, we use Excel to ease our work, and people who know the use of PivotTable can generate reports with a fingertip. But in PivotTable there have few limitations that you can't use Functions. So here comes PowerPivot for Excel to give advanced flexibility over PivotTable. In PowerPivot for Excel and Power BI, you can write measure to give flexibility in report generating. So how this title is related to the [...]

Sum of Current, Previous, Next Month Values using DAX in Power BI and Excel

  You have data in below table (Table: 01) from which you want to get price of previous, current, next month for each row in three new columns in Power BI and Excel PowerPivot (Table: 02). Table: 01 Table: 02 You can do it by using below given DAX formula. This formula will work if you have installed any one of Excel 2016 or above, Microsoft Power Query for Excel (Add-in for Excel 2010, 2013), [...]

Go to Top