Forum Discussion

slavisha84's avatar
slavisha84
Icon for Helper I rankHelper I
5 years ago

Weekly summary by current Week, MTD, QTD and YTD

Hello there,  I have two tables, FiscalCalendar, and Revenue that use dates as cross-references. The fiscal Calendar table contains: Date, FiscalWeek, FiscalMonth, MonthName, FIscalQuarter, and Fis...
Need Help
Tutorial Requests
slavisha84's avatar
slavisha84
Icon for Helper I rankHelper I
5 years ago

Since I am not good with DAX yet and I don't understand your response above, I tried to write the summary table in python and upload it into PowerBI. I can see the table in power BI now which is exactly the same format with the same calculation as in the example in my first post. Is there a way I can now show this table as is next to my charts in the visual section? So the calculations are done in python and i don't need to change anything just to show these 5 columns with 5 rows as they are next to my other visuals. How do i do that?

Otherwise, if someone could help me write this in DAX I would so appreciate you and i don't mind even paying for it at this point because it is very urgent.