Calculate Completed Refunds - DAX Challenge

preview_player
Показать описание
Here to another interesting DAX / Data Modeling problem. Enjoy!

- - - - Download Data - - - -

- - - - Post your answers here - - - -

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

---
Artist Attribution
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
  1. Goodly
  2. Power BI
  3. Power Query
  4. Excel
  5. DAX
  6. M Formulas
Рекомендации по теме
Calculate Completed Refunds 0:04:37

Calculate Completed Refunds - DAX Challenge

Calculate Refunds - 0:11:41

Calculate Refunds - DAX Challenge Solution

Calculate Customer Refunds 0:09:57

Calculate Customer Refunds with DAX in Power BI

DAX CALCULATE Function 0:08:45

DAX CALCULATE Function Made Easy to Understand (just one word)

How to Calculate 0:05:19

How to Calculate Percentage in Power BI DAX

DAX Percentage Calculations 0:03:51

DAX Percentage Calculations

How to Explain 0:00:26

How to Explain DAX Functions in a Power BI Interview🤔 #Shorts

Power BI - 0:00:19

Power BI - DAX function - ALLExcept

DAX - Percent 0:09:06

DAX - Percent of Total vs Percent of Grand Total

𝐂𝐚𝐥𝐜𝐮𝐥𝐚𝐭𝐢𝐨𝐧 of Customer 0:04:13

𝐂𝐚𝐥𝐜𝐮𝐥𝐚𝐭𝐢𝐨𝐧 of Customer Retention Rate in Power BI (DAX)

Power BI - 0:00:18

Power BI - DAX function - STDEVX

DAX Fridays #186: 0:06:18

DAX Fridays #186: CALCULATE vs CALCULATETABLE

How to Use 0:00:59

How to Use the DAX ALL Function to exclude slicers #powerbi #pbi #dax #powerbiforbeginners #filter

No More DAX? 0:07:30

No More DAX? Power BI’s NEW Feature Explained (File Included)

Running/Cumulative Totals for 0:00:58

Running/Cumulative Totals for Date & Non-Date Columns | Power BI DAX Tutorial | MiTutorials

IF ERROR Power 0:00:25

IF ERROR Power BI Dax

DAX Fridays! #5: 0:14:29

DAX Fridays! #5: CALCULATE (Part 1)

Learn DAX Basics 0:00:23

Learn DAX Basics in 30 Minutes | shorts | yt studio|

DAX Fridays! #211: 0:06:28

DAX Fridays! #211: Allocation calculations grouped by period | GROUPBY , CURRENTGROUP

Power BI DAX 0:00:56

Power BI DAX Function - CalendarAuto #shorts

Calculate Previous Weeks 0:12:09

Calculate Previous Weeks Sales - Advanced DAX in Power BI

DAX Is Easy, 0:47:19

DAX Is Easy, CALCULATE Makes It Hard

What is the 0:00:38

What is the week number DAX Function in Power Query? #powerbi #powerbidax #powerquery #dax

Measures vs. calculated 0:06:00

Measures vs. calculated columns in DAX and Power BI

Комментарии
Автор

Thanks for the challange.
a calculated column in Sales:

completed refunds amount =
VAR __table =
FILTER(
RELATEDTABLE(Refunds),
Refunds[Refund Status] = "Complete"
)
RETURN
IF( COUNTROWS(__table) = 2, SUMX(__table, Refunds[Units Refunded])) * RELATED(Products[Price])

janwillemvanholst
Автор

Next 2 da dudes in da cube you're the best bro 💯 💪

jsorrisone
Автор

Thanks for the challenge Chandeep! Looking forward to giving it a try and viewing the solutions. Thumbs up!!!

wayneedmondson
Автор

bro how to do page navigation using dax

ahmadalishaik
Автор

Done! 👍 can you Post the answer for reference?

sane
Автор

Sir some one ask with me in interview ।। How can calculate those person who got the salary after employees was regined.

rakeshchaudhary
Автор

hi chandeep, you are being awesome and i havebeen watching your videos on a daily basis,
i have encounter a problem,
i have 2 table and have similar columns in both the table and want to give a flag in one of those table that
if the common values in those table exists in a first table,
i want to give a flag in the first table that if the value is common than it should give 1 if not than 0

amitvaishnav