2021. dec 07.

Power BI playing with dates

írta: dataanalyticsdemo
Power BI playing with dates

Data source: Superstore sample

Filter Sum of profit AFTER A SPECIFIC DATE with only GUI options:

Profit is set to whole number just for readability.

--------------------------------------------------

Filter with parameter and DAX formulas:

1. Add paramter

2. Convert parameter to query for referencing it in the formula:

3. Create DAX formula

4. Check if results are the same

Excel check returns the same,so it works.

----------------------------------------------------------------------

Use filters to select specific data:

 Some other touches:

Szólj hozzá